Turning off "save changes" prompt

[TC]

I use an Excel worksheet very frequently which always asks "Do you want
to save changes" when you close it, even when no changes have been made
at all. This is very annoying and does not seem to be connected to my
main Excel setup, as all other Excel worksheets I use on a daily basis
do not give this prompt unless a change has actually been made. The
"save" option under "options" does not seem responsible, as the setting
in the problematical worksheet is the same as for other worksheets. Is
there any way of resolving this?

Many thanks
TC

 

[Guest]

If you have any formulas that use the TODAY() or NOW() functions, it will
cause the prompt to show up.

 

[Jim Rech]

I'd guess this workbook uses some 'volatile' functions.

http://support.microsoft.com/kb/274500

--
Jim
|I use an Excel worksheet very frequently which always asks "Do you want
| to save changes" when you close it, even when no changes have been made
| at all. This is very annoying and does not seem to be connected to my
| main Excel setup, as all other Excel worksheets I use on a daily basis
| do not give this prompt unless a change has actually been made. The
| "save" option under "options" does not seem responsible, as the setting
| in the problematical worksheet is the same as for other worksheets. Is
| there any way of resolving this?
|
| Many thanks
| TC
|

 

[Guest]

I will suggest you Detect and Repair your MS office. And to do that, point to
help on MS excel standard tool bar then click on DETECT AND REPAIR. Check the
box (discard my customized settings and restore to default). If you are
prompted to insert your MS office CD on your CD-ROM, do so.

I hope this helps.

ObiAkpere