Excel2000 keeps asking me to save when no changes were made

[Guest]

Excel2000 keeps asking me to save when no changes were made. This only
happens on a few workbooks and has only been hapening the past 4 months. As
time goes on it is happening more frequently. Ran Norton Anti-Virus, no
viruses detected. Ran Spyware software, no problems there either.

 

[Ken Wright]

Have you got any of the following volatile functions in your workbook, as
the existence of any of these will cause that message, because that function
is recalculated every time you open the workbook, and as far as Excel is
concerned that is a change. Most common one I would suggest is the TODAY()
function.

CELL,
INDIRECT,
NOW,
OFFSET,
RAND,
TODAY.

 

[Guest]

Ken, No there are no functions that would cause the workbook to update, such
ast date or recalculation. It doesnt happen to all of the workbooks. just
some of the and not all of the time. Some have no functions or formulars at
all in them just simple data in columns and rows with no references from one
cell to another. I might add that this happened to me once before when i had
Office 97. The way I resolved it then was to create a new workbook and do a
copy/paste from the bad one to the new one then delete the bad on. Same data,
same formulas but it worked. After that never asked to save again unless i
really did make changes. Problem it was needless to say very time consuming
to do that. Trying not to have to do it again but if i have to I don't want
to wait till it happens to too many files.

 

[Ken Wright]

If you have a file that you think shouldn't be calculating that you are able
to share then by all means send it on down and I'll happily take a look.
You'd have to take the NOSPAM bit out of my email address though.