Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheets with OFFSET command always ask if I want to SAVE
After I open a worksheet in which I have used the OFFSET command, I am always
asked if I want to save the changes, even if I have only looked at the file and not highlighted anything, made any changes. or even touched the mouse or keyboard during the time that the file was open. Is there any way to stop this? Jolly good Delaware lad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheets with OFFSET command always ask if I want to SAVE
Not if you are using the OFFSET function, which is one of the Volatile
functions. AREAS() OFFSET() CELL() INDIRECT() NOW() TODAY() RAND() Any one or more of these would cause the workbook changes. Gord Dibben On Sun, 1 Apr 2007 12:16:01 -0700, Jolly good Delaware lad <Jolly good Delaware wrote: After I open a worksheet in which I have used the OFFSET command, I am always asked if I want to save the changes, even if I have only looked at the file and not highlighted anything, made any changes. or even touched the mouse or keyboard during the time that the file was open. Is there any way to stop this? Jolly good Delaware lad |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheets with OFFSET command always ask if I want to SAVE
OFFSET is a Volatile function, which means it calculates when the file
is opened. The only way to change that behavior is to set the workbook's calculation style to Manual (Tools/Options/Calculation). Of course, you'll then have to manually calculate the book in order for it to be updated. In article , Jolly good Delaware lad <Jolly good Delaware wrote: After I open a worksheet in which I have used the OFFSET command, I am always asked if I want to save the changes, even if I have only looked at the file and not highlighted anything, made any changes. or even touched the mouse or keyboard during the time that the file was open. Is there any way to stop this? Jolly good Delaware lad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
Command Button Prompt Save As? | Excel Discussion (Misc queries) | |||
How to create command button to save the dates and time | Excel Discussion (Misc queries) | |||
OFFSET command and linked documents | Excel Worksheet Functions | |||
How do i convert excel to csv in command line? ( not save as) | Excel Discussion (Misc queries) |