Prompt to save when no changes made

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
 
Back
Top