Save Changes Prompt
 

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


--
ExcelQuestion
------------------------------------------------------------------------
ExcelQuestion's Profile: http://www.excelforum.com/member.php...o&userid=34059
View this thread: http://www.excelforum.com/showthread...hreadid=553719

Save Changes Prompt
 

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?





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



"ExcelQuestion" wrote in message
news:ExcelQuestion.29pm93_1150821905.8417@excelfor um-nospam.com...

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


--
ExcelQuestion
------------------------------------------------------------------------
ExcelQuestion's Profile: http://www.excelforum.com/member.php...o&userid=34059
View this thread: http://www.excelforum.com/showthread...hreadid=553719

Save Changes Prompt
 

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

On Tue, 20 Jun 2006 19:05:33 +0200, "Ron de Bruin"
wrote:

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

Save Changes Prompt
 

Thanks Gord

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



"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
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

On Tue, 20 Jun 2006 19:05:33 +0200, "Ron de Bruin"
wrote:

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

Save Changes Prompt
 

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

Ricky


--
ExcelQuestion
------------------------------------------------------------------------
ExcelQuestion's Profile: http://www.excelforum.com/member.php...o&userid=34059
View this thread: http://www.excelforum.com/showthread...hreadid=553719