Prompted to save

H

hetherjw

Hi All,

I have a sheet that promts me to save even if I have not made changes.
Any way to disable the waring? Is this some setting that I cannot track
down? Thanks, Hetherjw
 
A

Alan

Do you have =TODAY() or =NOW() in the sheet?
If so the sheet will consider itself changed when you open and trigger the
message,
Regards,
Alan.
 
H

hetherjw

Alan,

I think that is the cause of my proble I just can't find the cell tha
has the formula. I am trying to use the Go To command to track i
down.

Thanks for your help,

hetherj
 
A

Alan

Try clicking 'Tools' > 'Options' , on the 'View' tab check 'Formulas' > OK
This will display all the formulas as they are written in the cells as
opposed to the results of them and should make it easier to find what you're
looking for,
Regards,
Alan.
 
Top