ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel 02 always asks "save changes?" when closing unaltered file (https://www.excelbanter.com/excel-discussion-misc-queries/72171-excel-02-always-asks-save-changes-when-closing-unaltered-file.html)

6foot6

excel 02 always asks "save changes?" when closing unaltered file
 
After opening an existing Excel file, a popup window asks if I want to save
changes, even though nothing was changed.

Elkar

excel 02 always asks "save changes?" when closing unaltered file
 
There may not have been any manual changes, but it is likely that some sort
of change did occur. Commonly this may be from the use of the NOW() or
TODAY() functions. These update automatically to new values when the
worksheet is opened, thus, there has been a change.

HTH,
Elkar


"6foot6" wrote:

After opening an existing Excel file, a popup window asks if I want to save
changes, even though nothing was changed.



All times are GMT +1. The time now is 02:44 PM.

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