Didn't you get a notice when you opened that other file on the pc with the newer
version of excel that excel likes to recalculate when opening workbooks that
were saved in older workbooks? (Or words to that effect.)
And if excel is recalculating (for any reason), it'll think that the workbook is
dirty (mark it as having changed since the last save (or when it was opened)).
Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl
It might work for you.
SLB, accounting wrote:
I asked this question before but realize I was a little vague in my details.
How can I bypass or disable the warning in Excel 2003 that asks if I want to
"save changes before closing" when in fact I have made no changes. I have NO
formulas in the file that would cause an automatic update.
I did an experiment:
We have a computer with an older version of excel and I opened an excel file
on a shared server, made no changes to the file, and then closed it. No
warning appeared. I came to my computer, (with the new Excel 2003), opened
the same excel file, made no changes, and closed it. Sure enough the warning
alert appeared asking me if I wanted to save changes. This happens on every
single excel file I open. Every one!
I am wondering if it's not something in the way excel opens. Please someone
help.
--
Dave Peterson