Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel ask to save when no changes were made?
This does not pertain to a new document. I open an existing document just to
look at it, and when I go to close it, Excel asks if I want to save the document. No changes were made, so it shouldn't have to be saved. It's annoying. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel ask to save when no changes were made?
Mike
One explanation could be that there is a time formula in a cell that has updated on openeing so the worksheet will have changed. -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''''s razor (Abbrev) "Mike" wrote: This does not pertain to a new document. I open an existing document just to look at it, and when I go to close it, Excel asks if I want to save the document. No changes were made, so it shouldn't have to be saved. It's annoying. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel ask to save when no changes were made?
One cause could be the use of volatile functions in formulas such as:
CELL INDIRECT INFO NOW OFFSET OFFSET RAND RANDBETWEEN TODAY And in certain very rare applications: INDEX -- Biff Microsoft Excel MVP "Mike" wrote in message ... This does not pertain to a new document. I open an existing document just to look at it, and when I go to close it, Excel asks if I want to save the document. No changes were made, so it shouldn't have to be saved. It's annoying. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel ask to save when no changes were made?
To be exact if your workbook contains any volatile function (even if the
value calculated does not change) the workbook will be deemed as changed and a save will be required... Volatile functions include Rand, Now, Today, Cell, Offset, Info and Indirect. UDF's can also be volatile... -- HTH... Jim Thomlinson "Mike H" wrote: Mike One explanation could be that there is a time formula in a cell that has updated on openeing so the worksheet will have changed. -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''''s razor (Abbrev) "Mike" wrote: This does not pertain to a new document. I open an existing document just to look at it, and when I go to close it, Excel asks if I want to save the document. No changes were made, so it shouldn't have to be saved. It's annoying. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel ask to save when no changes were made?
Mike...
Sometimes Excel will ask you to save if you change the position of the cursor within the file as well. Hope all these help HpY "Mike" wrote: This does not pertain to a new document. I open an existing document just to look at it, and when I go to close it, Excel asks if I want to save the document. No changes were made, so it shouldn't have to be saved. It's annoying. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel prompts to save when no changes made | Excel Discussion (Misc queries) | |||
save changes in Excel window appearing when none have been made? | Excel Discussion (Misc queries) | |||
why does excel ask to save changes when none have been made? | Excel Discussion (Misc queries) | |||
Why am I prompted to save changes I haven't made in Excel 2002? | Setting up and Configuration of Excel | |||
when I save a worksheet made in excel 2003 to excel 97, | Excel Discussion (Misc queries) |