ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Do you want to save changes? (https://www.excelbanter.com/excel-discussion-misc-queries/1422-do-you-want-save-changes.html)

NWH

Do you want to save changes?
 
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

--
Regards
Frank Kabel
Frankfurt, Germany

"NWH" schrieb im Newsbeitrag
...
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




All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com