| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save changes? even when you've made none
Everytime I close a certain file, it always asks me if I want to save
changes, even though I didn't do anything. I just opened the file, looked at, then closed it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save changes? even when you've made none
Best guess is that you have a volatile formula somewhere in the file.
Volatile formulas are formulas like Now(), Rand() or such that recalculate every time a calcuation runs. So when you open the book, it gets calculated and even if the volatile function returns the exact same value as it started with XL is going to think that the file needs to be saved... -- HTH... Jim Thomlinson "Donna" wrote: Everytime I close a certain file, it always asks me if I want to save changes, even though I didn't do anything. I just opened the file, looked at, then closed it. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save changes? even when you've made none
Some worksheet functions like NOW() and TODAY() are "volatile" and are recalculated when the worksheet is opened. Since these values (may) change, Excel treats the workbook as if it had been changed and prompts to save the changes. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 20 Nov 2008 13:10:01 -0800, Donna wrote: Everytime I close a certain file, it always asks me if I want to save changes, even though I didn't do anything. I just opened the file, looked at, then closed it. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save changes? even when you've made none
This bulletin board is awesome! Thank you for your help... this is exactly
what I have going on... there is a formula today()... Thanks again!! "Chip Pearson" wrote: Some worksheet functions like NOW() and TODAY() are "volatile" and are recalculated when the worksheet is opened. Since these values (may) change, Excel treats the workbook as if it had been changed and prompts to save the changes. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 20 Nov 2008 13:10:01 -0800, Donna wrote: Everytime I close a certain file, it always asks me if I want to save changes, even though I didn't do anything. I just opened the file, looked at, then closed it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Asked to save changes although none were made. | Excel Discussion (Misc queries) | |||
| save changes when no changes made | Excel Discussion (Misc queries) | |||
| File Save although no changes were made | Excel Discussion (Misc queries) | |||
| Excel2000 keeps asking me to save when no changes were made | Excel Discussion (Misc queries) | |||
| Save prompt when no changes made | Excel Discussion (Misc queries) | |||
Linear Mode
