Do you want to save changes?

[NWH]

Everytime a shared workbook is opened and then closed without changes being
made to it, users are prompted by the following:

This document has been modified. Do you want to save changes?

Yes: Saves your changes.
No: Discards your changes.
Cancel Keeps this document open.

Using excel 2002. Again, no changes are made and the prompt still comes up.

Thanks in advance for any help.
NWH

 

[Frank Kabel]

Hi
not sure but could be a 'feature' of shared workbooks. another reason
could be the use of volatile functions:
http://www.decisionmodels.com/calcsecretsi.htm