Asked to save changes although none were made.

  • Thread starter Thread starter SSG Curly
  • Start date Start date
S

SSG Curly

When I open a file, I would look at the data on several worksheets within the
workbook. When I close the file, I get the dialog box... "Do you want to
save changes?" even though no chages were made to any data in the file.
 
Something may be changing that you're just not seeing.

Try this. Open Excel and type a single letter into a cell on one sheet in
the empty workbook presented at opening. Save that workbook. Close that
workbook. Open that workbook back up, browse around in it and then close it.
You shouldn't get a prompt to save changes. If you don't, it means all is
working like Excel thinks it should, so it is thinking that something changed
in that other workbook of yours.
 
This usually means that there is a DATE() or TIME() function being used
somewhere in the sheet. Maybe only in a print header or footer.

Might also be a link to some external data.
 
Something may be changing that you're just not seeing.

Try this.  Open Excel and type a single letter into a cell on one sheet in
the empty workbook presented at opening.  Save that workbook.  Close that
workbook.  Open that workbook back up, browse around in it and then close it.
 You shouldn't get a prompt to save changes.  If you don't, it means all is
working like Excel thinks it should, so it is thinking that something changed
in that other workbook of yours.





- Show quoted text -
Click to expand...

It will also think something has changed if you are using a different
version of excel then it was orignal done in.
Jay
 
This can happen if you have any volatile functions in your workbook,
eg formulae which include NOW, or TODAY, or OFFSET, or INDIRECT etc.
Excel automatically recalculates when the file is opened, thus it
appears it has changed.

Hope this helps.

Pete
 
Back
Top