| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forced to save - even if no changes
I have one file that when I close it, it always asks me if I want to save
changes, even if I didn't even breathe while it was open. What gives? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Forced to save - even if no changes
"RJB" wrote:
I have one file that when I close it, it always asks me if I want to save changes, even if I didn't even breathe while it was open. What gives? One reason is that your file probably contains volatile functions, eg: OFFSET -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Forced to save - even if no changes
If the workbook you opened was created in an earlier version of Excel you will
get the "save changes" message. Save as your current 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 Wed, 12 Dec 2007 18:26:03 -0800, RJB wrote: I have one file that when I close it, it always asks me if I want to save changes, even if I didn't even breathe while it was open. What gives? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forced reboots -- Making Excel save always before file close | Excel Discussion (Misc queries) | |||
| Forced Scaling | Charts and Charting in Excel | |||
| how to get slope with a forced intercept of zero | Excel Worksheet Functions | |||
| Forced return?? | Excel Worksheet Functions | |||
| Forced Distribution | Excel Worksheet Functions | |||
Linear Mode
