Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What causes excel to prompt to save a file upon exit. I have made no changes
and the file has no external links. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sarah
If the workbook you opened was created in an earlier version of Excel you will get the "save changes" message. Save as 2003 version. You will also get the message if you have used any volatile function(s) in your workbook. Could be a NOW() or TODAY() List of volatile functions........ AREAS() OFFSET() CELL() INDIRECT() NOW() TODAY() RAND() Any one or more of these would cause the workbook changes. Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 16:08:00 -0800, Sarah wrote: What causes excel to prompt to save a file upon exit. I have made no changes and the file has no external links. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you so much. That was it!
"Gord Dibben" wrote: Sarah If the workbook you opened was created in an earlier version of Excel you will get the "save changes" message. Save as 2003 version. You will also get the message if you have used any volatile function(s) in your workbook. Could be a NOW() or TODAY() List of volatile functions........ AREAS() OFFSET() CELL() INDIRECT() NOW() TODAY() RAND() Any one or more of these would cause the workbook changes. Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 16:08:00 -0800, Sarah wrote: What causes excel to prompt to save a file upon exit. I have made no changes and the file has no external links. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing data in .csv file | Excel Discussion (Misc queries) | |||
Is there any File Auto Save Function for Excel and Word 2007 (Bet | Excel Worksheet Functions | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Save Excel File every wednesday VB Script Help !! | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) |