Save Changes Prompt

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ExcelQuestion - 20 Jun 2006 17:40 GMT

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

Signature

ExcelQuestion

Reply to this Message

Ron de Bruin - 20 Jun 2006 18:05 GMT

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?

Signature

Regards Ron De Bruin
http://www.rondebruin.nl

> Hello,
> Why does the "Do you want to Save Changes you made to [filename.xls]?"
[quoted text clipped - 9 lines]
> Thanks,
> Ricky

Reply to this Message

Gord Dibben - 20 Jun 2006 20:14 GMT

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
>
[quoted text clipped - 15 lines]
>Excel likes to recalculate workbooks created in earlier versions. Is this
>the case in your situation?

Gord Dibben MS Excel MVP

Reply to this Message

Ron de Bruin - 20 Jun 2006 20:45 GMT

Thanks Gord

Signature

Regards Ron De Bruin
http://www.rondebruin.nl

> Ron
>
[quoted text clipped - 35 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message

ExcelQuestion - 20 Jun 2006 23:25 GMT

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

Reply to this Message