Saving Problem

  • Thread starter Thread starter Robert Nguyen
  • Start date Start date
R

Robert Nguyen

One of my Excel files keeps asking me to save my changes
when I try to close, even though I have already saved it
several times. Has anyone else had this problem? Could
it be something in my VBA code?
 
Hi

It may be that you have a 'volatile' function in your sheet - such as RAND()
or TODAY() (or many others) which calculate every time you change anything
on the sheet. This will make the sheet believe a change has been made and
ask if you want to save.

Andy.
 
Why would you not just try closing it and it will prompt
to save. Hit Save and it will close right away too. Easy
as that.
 
Thanks Amy, but it's not me that I'm worried about. I
created this report for other people, and some of these
people would get nervous for anything that is unusual.
Even as minor as this problem. I'm just trying to prevent
unnecessary questions.
 
Back
Top