Save options on excel

H

Helen@GM

Am using Excel 2000. Every time I open and close a document the "Do you want
to save changes?" box comes up even though I've made no changes. How do I
change this so this box only comes up when changes have been made?
 
B

Bob Phillips

Helen,

That can happen if there are any volatile functions in the workbook that
will recalculate on opening, such as =NOW().

If you have these, not much you can do about it, that is the way Excel
works.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
H

Helen@GM

Hi Bob,

Thanks for that but don't think that is the reason as even when a blank
unnamed doc is open it will also ask if I want to save changes when I try to
shut down Excel. It appears to be something to do with the set-up but can't
find a way to change it.

Any other ideas?

Helen
 
Top