Save Changes with no change to save

[ste]

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

 

[ste]

I got it!

the problem is SUMIF...

is it a normal behaviour?

 

[okaizawa]

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/

 

[sajay]

there are other formulas and situations
if the calculation/ circular reference is on any sheet it may happen.

 

[ste]

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