Asked to save changes although none were made.

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.
 
J

JLatham

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.
 
G

Gary''s Student

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.
 
J

jlclyde

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 -

It will also think something has changed if you are using a different
version of excel then it was orignal done in.
Jay
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top