ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why am I prompted to save a file when nothing has changed? (https://www.excelbanter.com/excel-discussion-misc-queries/24129-why-am-i-prompted-save-file-when-nothing-has-changed.html)

SimonD

Why am I prompted to save a file when nothing has changed?
 
In Excel I open an existing file to review the contents, but don't change
anything. When I then try to close the file I am prompted to "Save changes"
when nothing has actually changed. How can I stop this prompt appearing?


Hi

Your book probably contains some volatile functions (eg TODAY()) which makes
it recalculate on opening.

--
Andy.


"SimonD" wrote in message
...
In Excel I open an existing file to review the contents, but don't change
anything. When I then try to close the file I am prompted to "Save
changes"
when nothing has actually changed. How can I stop this prompt appearing?




Lady Layla

Was this file created in the exact version of Excel you are using now? If not,
Excel automatically asks to save it


"SimonD" wrote in message
...
: In Excel I open an existing file to review the contents, but don't change
: anything. When I then try to close the file I am prompted to "Save changes"
: when nothing has actually changed. How can I stop this prompt appearing?




All times are GMT +1. The time now is 08:34 AM.

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