save changes when no changes made

[Guest]

When I go to close an Excel document, I am asked about saving changes even
though none have been made. I have already searched this question here and
every suggestion has not helped. I do not have any macros in the workbook,
no links to any other workbooks and it does not have any functions that may
cause this (I know that TODAY(), NOW(), etc.) can cause this.

Any suggestions to find what I have stuck in the file or a setting wrong? I
have Excel 2002

 

[Dave Peterson]

If the workbook was created in an earlier version of excel, then xl2002 will
recalculate it when it opens.

And then when you close the workbook, excel thinks that you should be prompted.

I just saved as the newer version and the problem would go away.

But I've seen posts that this hasn't worked for a few people. They actually
ended up just copying the data from the old workbook and pasting it into a new
workbook. (Or they copied the worksheets into a new workbook--I don't recall.)

 

[Gord Dibben]

Elaine

There are a few other volatile functions that would cause this.

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

Dave is probably correct with the older version.newer version guess.


Gord Dibben MS Excel MVP