Prompt to save when no changes made

I have a file that was coverted from 1997 version of excel to the 2003 
version of excel.  The file has no volitile functions (eg. "now" formula, 
"offset" etc), however I am prompted to save changes on closing the file, 
even when no changes were made.  I am on automatic calculation, but this 
ususally has no effect on the save prompt.

How do I stop Excel from prompting to save when no changes were made?

Thanks

0
11/16/2004 5:59:03 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
168 Views

Similar Articles

[PageSpeed] 22

Hi
some ideas:
- really no volatile function??
- maybe an event procedure which changes something in the background
- does this happen only after saved in Excel 97 (as Excel 2003
re-calculates the entire sheet in this case)

--
Regards
Frank Kabel
Frankfurt, Germany

"POWER CERTS" <POWERCERTS@discussions.microsoft.com> schrieb im
Newsbeitrag news:BA351AA6-2B03-4EB5-B8B1-690A986F4B6E@microsoft.com...
> I have a file that was coverted from 1997 version of excel to the
2003
> version of excel.  The file has no volitile functions (eg. "now"
formula,
> "offset" etc), however I am prompted to save changes on closing the
file,
> even when no changes were made.  I am on automatic calculation, but
this
> ususally has no effect on the save prompt.
>
> How do I stop Excel from prompting to save when no changes were made?
>
> Thanks
>

0
frank.kabel (11126)
11/16/2004 6:08:28 PM
Reply:

Similar Artilces:

Outlook / Office 07 changing the fonts?
I've just upgraded from Office 2003 to the Office 2007 public beta, and what's bothering me most at the moment is the ugly new application font, "Segoe UI". To my eyes it is truly ugly. So I set about changing it where I could in Outlook back to Tahoma. I've also switched off Cleartype! So far I've only managed to get rid of Segoe in the top mail grid and main body of the mail messages and the calendar navigator. Is there any way to change any more of the interface back to Tahoma or am I stuck with half and half? Which portion did you want to change? The m...

Changing the way Contacts are displayed on a shared contact list
I have two users sharing a contacts list on our exchange server. One user sees the contacts filed as First Name, Last Name while the other one sees them as Company, First Name, Last Name. I wish to force both users to view the contacts list in the same manner. I'm assuming it's a setting on their computers as the contact list is stored in a public folder on the Exchange server. Both users are running Outlook 2002 and Windows XP Pro. Thanks in advance for your help. BC ...

SQL Select Query Prompting for NonExistent Parameter
I'm using Access 97. I've entered the following SQL Query into the Query Tab. =================== SELECT * FROM tblVehicles WHERE fldVehicleTag = ABC123; ==================== When I double click the Query to execute: Instead of returning the recordset Access prompts me for a Parameter. When I enter the tag # --> ABC123 it returns the correct record. Why am I being prompted for a Parameter and how do I stop it? Thanks David On Wed, 17 Mar 2010 22:25:13 -0400, "David" <NoWhere@earthlink.net> wrote: >I'm using Access 97. &g...

Saving Formatting in Pivot Tables
When I changed formatting in a pivot table, it returns to the default format when I make a change or close the file. Generally, in formats like font size, column width, etc. Is there a way to save/retain format changes in pivot tables? Thank you. right click in the table and go to the bottom to select "table options". It's there. >-----Original Message----- >When I changed formatting in a pivot table, it returns to >the default format when I make a change or close the >file. Generally, in formats like font size, column >width, etc. Is there a way to...

Ignoring a Macro when "Save as"
I have a Workbook with the following macro. I want to let the user "Save As" and rename the workbook and not have the macro take place when the newly named workbook gets re-opened. Anyone have any ideas? Here is the current macro, nothing fancy just setting some default values upon opening the workbook: Private Sub Workbook_Open() With Sheets("Fab Sheet") ..Range("E15,E18,E22,E26,E30,E37,E43").Value = 1 ..Range("A11,B11,A13,B17,C27,C31,B35,B41,B50,B52,C55").Value = 0 ..Range("B3..B8").Value = "" End With End Sub The macro is locat...

Globally changing Outlook Contacts
Hi group I am using Outlook XP (2002). I desire to change the way each contact is viewed in my contact folder. This would require changing the "File As" field on every contact. Any thoughts? Regards Warwick You'd have to use code to do that. This MS KB article may help: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q291144 -- Russ Valentine [MVP-Outlook] "Warwick Cunningham" <someone@somewhere.com> wrote in message news:LKD2b.63817$bo1.62022@news-server.bigpond.net.au... > Hi group > > I am using Outlook XP (2002). I desire to change th...

change text and icon of a XP grouped taskbar button
Hi I need to change the text and icon of the taskbar button that XP collects simular buttons under, (after choosing "Group simular taskbar buttons" in the taskbar properties) Can anyone give me directions on where to start looking? thanks and regards Anders Sandberg ...

Save as Web Page..
Does anyone know how to not include the details on the side. I want to save it as just a monthly calendar in web format but even if I clear the check mark that says show detail it still saves it as a detailed appointment column on the right ...

How to change Machine name without Prompt for credentials
Hi I'm hoping there's a way to do this, but I'm not sure. I have an OU configured which contains some Computer accounts and a couple of user accounts. To one of the accounts I've delegated permissions to add and delete "computer" objects in that OU. When I'm logged into one of the computers in the OU and I try to rename the Computer, I'm prompted for credentials, even though I'm already logged on using the delegated account. I enter the username/password and all is good but I'd like not to be required to enter the user/pass. Is the...

Synchronisation hangs during save of synchronisation log.
We're using Exchange Server 2000 with an Outlook 2002 client. When we synchronise the offline folders outlook hangs after it tries to save the synchronisation log (at 50%). Can somebody help please? Thanks in advance! ...

Changing printer while excel-file is open
Hello, I have an Excel-file with about 2MB which contains a lot of formattings and named cells. If I now change my Default Printer in the Control Panel while this file is open then Excel needs a few seconds to overtake this new setting. If I then take a look at my open file then I suddenly can see the pagebreaks which were not there before. After that my program tries to hide/unhide columns. But this action now takes much more time than before changing the Default Printer - before it needed about 0,1s and now about 4,0s. I have a similar Excel-file where this does NOT happen. So it must depen...

task view changed in to do bar
outlook 2007 froze when i closed it after i made a number of changes to my contacts. when i rebooted and opened outlook, the task view in my to-do bar had changed from the "to-do list" to the "next 7 days" view (which i had customized earlier in the day). i cannot find any way to change the task view that appears in the to-do bar back to the to-do list. i have seen one or 2 posts on other forums where users have reported the same problem, but no resolution. does anyone know of a solution? thanks! Right click on the "Arranged By" column in the To...

loading and saving a transparent CImage
Could someone give me some direction on how to load/save a gif with transparency using CImage? Currently I'm loading them and then setting the transparency index using gif header, but can't get them to save correctly at all, even if I rewrite the background color in the header. Thanks, Scott Hello Scott, Thanks for your post. We will look into it and reply with more information here. Please post here if you have any more concerns. Regards, HuangTM Microsoft Online Partner Support MCSE/MCSD Get Secure! -- www.microsoft.com/security This posting is provided "as is"...

Disable save warnings on a csv
Hi All, Is there a way to disable all the warnings when dealing with a CSV File? I do a lot of work with them and it is starting to get annoying. I don't want a macro in the file, because then others will get confused when it displays the message to enable/disable them. Thanks Chad Hi, Well you could put the macro in the Personal Macro Workbook and then it would be available for you but not for the other users. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Chad Cameron" wrote: > Hi All, > > Is there a way to disable all the ...

w2k3sp1 and owa password change
after applying the windows 2003 sp1 , owa 2003 password change cannot work correctly. changed password works in few minutes and old password still works.. thanks for helps... ...

Changing password
Have two different domains. exchange is in one domain and the users that can not change their password is in a different domain. The way the users try to change their password is via outlook. Tools->options->advanced->customs forms->password Then that get an error about password didnt change, What version of Exchange, and why are you trying to change passwords via Outlook? -- Ben Winzenz Exchange MVP "spiv007" <spiv007@discussions.microsoft.com> wrote in message news:282F57CD-38D2-4500-8EC8-B8038CC31318@microsoft.com... > Have two different domains. e...

How do I save Contacts and e-mail to jump drive?
I want to back-up my information from Outlook (contacts and e-mails). What is the stemp-by-step process for this? "dalejellison" <dalejellison@discussions.microsoft.com> wrote in message news:E1849E69-D9B5-4B98-9309-B8EE59BBBB15@microsoft.com... >I want to back-up my information from Outlook (contacts and e-mails). What > is the stemp-by-step process for this? No need to post more than once. -- Brian Tillman [MVP-Outlook] ...

Error when saving
I'm using Excel 2002/XP and getting the following error when trying to save. "Excel could not save all the data and formatting you recently added to filename.xls" I have seen a Knowledge Base article that this can occur in 2000 when using a heavy amount of conditional formatting. But that post says when formatting is done to more than 2,050 rows. And I'm not formatting that many rows. Mine is approx. 550+ Anyone know what is going on here and what I can do about it? Thanks, David do you format lots of cells individually? XL: Error Message: Too Many Different Cel...

Prompting for customer information
Does anyone know of a way to force the POS to prompt for an E-mail address at each transaction? I would like to start sending coupons and such using E-mail. Thanks in advance, Scott Scott, There is no such feature out of the box with RMS, however we have two applications that are very similar in nature that could be easily modified to suit your needs. If you are interested please drop me a line at 1-888-267-RITE or drop me a line at rsakry@rite.us. -- Thank you, Ryan Sakry Program Manager Retail Information Technology Enterprises (RITE) rsakry@rite.us http://www.rite.us 320-230...

Save Record
In a modal pop up form's subform I wish to save a record without having to exit it so that a report reflects the current data in a control in the subform. Can anybody help please. -- Grimwadec "Grimwadec" <Grimwadec@discussions.microsoft.com> wrote in message news:35553A46-0359-44E1-9494-40A730112C26@microsoft.com... > In a modal pop up form's subform I wish to save a record without having to > exit it so that a report reflects the current data in a control in the > subform. Can anybody help please. > -- > Grimwadec In code behind th...

Office 2008 causes fatal conflict ("black screen of death") when trying to save
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello all, I'm in some rather dire need of assistance - any help you could give me regarding this topic would so much appreciated! The problem is this: We are a college music department trying to run a suite of iMacs over a Windows network. The iMacs are locked to their maximum level, so only administrators can perform updates (regular users can't even, for example, save a new "Normal" Word document template!). More often than not, whenever we try to save projects (in all applications but most noticabl...

Changing printed image size
I'm new to Publisher 2007. I'm trying to make a simple ad to put in a newspaper and have used "The Works" template in Advertisements. I used custom size and changed it to 3"x3" to fit the publications 3"x3" ad layout size spec. When I print the ad the printed image is only 2"x2". What am I doing wrong and how do I get the printed image upsized to 3"x3"? Thanks! -- Jake ...

Pb when saving my CRM credentials in Windows XP
It seems that there is an issue since I am saving my CRM credentials on my XP machine (sp2). I created a link on the desktop but most of the time I cannot access the server and have a IE page saying that IE cannot display this page. Now I have removed the password reminder from windows it seems to be fine (I log from a different domain than the one CRM is installed on). Any idea? Thanks Eric ...

Re: No "Save As" options in Word 2000
It's been a long time, but I would like to re-open this (now expired) thread (see below) because the problem persists. IIRC the advice at the time was to repair the Office installation, which I did, but the repair didn't help. Any more ideas? Actually, what I would really like to do on this Windows 2000 machine (which I don't use on a regular basis, hence the delay in picking this thread up again), is to install Office 2003 (I actually bought an Office 2003 CD for this purpose), but the machine refuses to install it. Perhaps I should start a new thread for this...

Saving 2007 Access database as 2003
I am struggling to save a 2007 Access database as a 2003 database. What is confusing is that you have to be in it otherwise the option is greyed out, but when it shows the name of the database with the .mdb extension and I click on Save it gives a message with words to the effect of saying that I am in the database and the file cannot be saved when I am in it. Somewhere in the process it said that the file had to be closed and did I want that and I accepted that but nothing was closed in the process. Thank you for any help. What I have done is to create a blank .mdb database...