Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
System asks to save when no changes made?
Any ideas why, when I open a sheet and don't make changes,
when I go to close the sheet, system asks me if I want to save. This seem to only happen with some files? Is there a setting somewhere on the file or the system setting? Any ideas welcome? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
System asks to save when no changes made?
One possibility is that you have some 'volatile functions' in these
workbooks. Take a look at Charles Williams' WebPage for a listing. http://www.decisionmodels.com/calcsecretsi.htm HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Any ideas why, when I open a sheet and don't make changes, when I go to close the sheet, system asks me if I want to save. This seem to only happen with some files? Is there a setting somewhere on the file or the system setting? Any ideas welcome? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
System asks to save when no changes made?
There could be a =NOW() formula somewhere for the current date, which
will update to today's date, for example. Or they may be an Auto_open macro running that does something which may not be visible. "Megan" wrote in message ... Any ideas why, when I open a sheet and don't make changes, when I go to close the sheet, system asks me if I want to save. This seem to only happen with some files? Is there a setting somewhere on the file or the system setting? Any ideas welcome? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Each time I close an Excel file, it asks if I want to save. | Excel Discussion (Misc queries) | |||
Excel asks to save an unchanged document. Why? | Excel Discussion (Misc queries) | |||
excel 02 always asks "save changes?" when closing unaltered file | Excel Discussion (Misc queries) | |||
why excel 2003 always asks to save or not | Excel Discussion (Misc queries) | |||
save changes when no changes made | Excel Discussion (Misc queries) |