View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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