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

Save Changes with no change to save
 

I got it!

the problem is SUMIF...

is it a normal behaviour?

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

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.

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