G Guest Feb 9, 2007 #1 What causes excel to prompt to save a file upon exit. I have made no changes and the file has no external links.
What causes excel to prompt to save a file upon exit. I have made no changes and the file has no external links.
G Gord Dibben Feb 9, 2007 #2 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
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
G Guest Feb 9, 2007 #3 Thank you so much. That was it! Gord Dibben said: 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 Click to expand...
Thank you so much. That was it! Gord Dibben said: 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 Click to expand...
