Save Excel file - prompts to save - no Volitile functions used
 

Since being upgraded to Excel 2003, a file has been prompting me to save,
even when no changes are made. I do have calculation set to automatic,
however I am not using a volitile function in the spreadsheet (ie. now,
offset, etc).

What else could be causing this?

Thanks

Hi
if the file ways created in an onlder excel version Excel re-calculates
the complete sheet on opening

--
Regards
Frank Kabel
Frankfurt, Germany


POWER CERTS wrote:
Since being upgraded to Excel 2003, a file has been prompting me to
save, even when no changes are made. I do have calculation set to
automatic, however I am not using a volitile function in the
spreadsheet (ie. now, offset, etc).

What else could be causing this?

Thanks

Newer versions of Excel like to re-calculate everything when opening a file
created in a previous version.

You did say you upgraded.

Does it ask every time even after you complied and saved?

There are more Volatile Functions than the average user thinks there are.

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

Also, do you have "Iteration" checked? Uncheck if so.

Gord Dibben Excel MVP

On Mon, 1 Nov 2004 12:07:03 -0800, "POWER CERTS"
wrote:

Since being upgraded to Excel 2003, a file has been prompting me to save,
even when no changes are made. I do have calculation set to automatic,
however I am not using a volitile function in the spreadsheet (ie. now,
offset, etc).

What else could be causing this?

Thanks