File Always Asks "Save Changes Y/N" even when no changes made

[Guest]

Ref : Excel 2000 Win 2000 Workstation
I have an XLS file with NO MACROS in it (all removed now ... did exist) and
when it loads, if I immediately close the window Excel asks me do I want to
save changes even though nothing has been changed. This happens on several
different PCs

I am not prompted that file is in wrong format or that there are links to
external files, or that there are Macros

I must now start deleting large sections of the spreadsheet in a copy of the
file and save and re-load after each deletion to see where the problem
arises, but if anyone has come across this before I'd be grateful for any help

Thanks
Nicholas B

 

[Dave Peterson]

Do you have any of these volatile functions in your workbook?

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

These evaluate with each calculation. And cause excel to think your workbook
has changed.

And excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?

 

[Guest]

Dave

Thanks for that, I do use some of those functions, so guess I'll just live
with the problem

Thanks again

Nicholas