Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
Save prompt | Excel Discussion (Misc queries) | |||
Save prompt for Excel 2003 | Setting up and Configuration of Excel |