| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Changes with no change to save
Hi,
I have a very basic excel file (no macros, no formulas like Now or Random), no external data... My problem is that it asks me to save changes even when there is no change to save. Do you have any suggestion? Many Thanks, ste |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save Changes with no change to save
I got it!
the problem is SUMIF... is it a normal behaviour? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save Changes with no change to save
ste wrote:
I got it! the problem is SUMIF... is it a normal behaviour? Hi, I suppose that SUMIF is not a volatile function. but the formula may have other volatile things. see also this: XL: "Save Changes in <Bookname" Prompt Even If No Changes Are Made http://support.microsoft.com/kb/274500/EN-US/ -- HTH, okaizawa |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save Changes with no change to save
there are other formulas and situations
if the calculation/ circular reference is on any sheet it may happen. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save Changes with no change to save
Thanks guys!
=SUMIF(H9:H23;G30;I9:I23) < this is ok (now...) =SUMIF(H9:I23;G30;I9:I23) < here is my mistake and excel asks for save changes... much obliged, Stefano |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
| Why system asks me to save change even after I call save method(VB.NET) | Excel Programming | |||
Hybrid Mode
