Save Changes Prompt

[ExcelQuestion]

Hello,
Why does the "Do you want to Save Changes you made to [filename.xls]?"
appear eventhough I didn't even enter a single keystroke, there aren't
any modules attached to the workbook, no private subs in the worksheets
and there aren't any calculation upon opening the file?

Normally, the save changes prompt appears only after I've started
working on the file.

Any ideas?

Thanks,
Ricky

 

[Ron de Bruin]

Hi ExcelQuestion

Maybe you have Volatile functions like

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

Or

Excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?

 

[Gord Dibben]

Ron

Peo has been chopping the list of volatile functions.

Latest is

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

ROWS, COLUMNS and INDEX off the list.


Gord

Hi ExcelQuestion

Maybe you have Volatile functions like

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

Or

Excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?

Gord Dibben MS Excel MVP

 

[Ron de Bruin]

Thanks Gord

 

[ExcelQuestion]

Hi Gord and Ron,
Very helpful as always. I had the =cell("filename",A1) function in th
tab. Mystery solved thanks to you both.

Rick