Prompt to save when no changes made

G

Guest

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
 
F

Frank Kabel

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel prompts to save when no changes made 2
How can you turn off "Do you want to save changes you made to ..." 2
prompt to save when closing file 2
Why does Excel ask to save when no changes were made? 4
No "save changes" when exiting Excel 2003 3
Excel Save Changes Prompt 1
stop prompt to save on no changes made 1
Turning off prompt to save file with no changes 5

Top