Microsoft Excel problem

  • Thread starter Thread starter Brock
  • Start date Start date
B

Brock

Hello, All!
I have an excel file (Office XP) which displays "Do you want to save the
changes you made to Business.xls? even without doing any input or changes.
What is the reason for this? Norton AV, Ad-aware & Spybot etc. declares
clean system. Any solution for this?

With best regards, Brock. E-mail: (e-mail address removed)
 
Excel recalculates the spreadsheet on opening, something as simple as a date
field (now()) will cause an obvious change to the spreadsheet as soon as you
open it, therefore excel will ask if you want to save the changes.

Macros may also be making changes to the contents even if those changes are
not noticable to the user.
 
Brock

Aside from macros making changes........

If you have volatile functions that update when the workbook is opened you
will be asked if you want to save changes.

This has been the case for all versions of Excel.

Volatile functions are those like..........

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

If this is not the case, be aware that when you open an older version workbook
in Excel 2002 and 2003 you will asked if you want to save changes. Once you
save that workbook, you will not be asked again.


Gord Dibben Excel MVP
 
Brock

Aside from macros making changes........

If you have volatile functions that update when the workbook is opened you
will be asked if you want to save changes.

This has been the case for all versions of Excel.

Volatile functions are those like..........

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

If this is not the case, be aware that when you open an older version workbook
in Excel 2002 and 2003 you will asked if you want to save changes. Once you
save that workbook, you will not be asked again.


Gord Dibben Excel MVP
 
Hello All,
There is not a single Now, Today or other mentioned functions in the
worksheet.

With best regards, Brock. E-mail: (e-mail address removed)
 
Back
Top