Worksheets with OFFSET command always ask if I want to SAVE

  • Thread starter Jolly good Delaware lad
  • Start date
J

Jolly good Delaware lad

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
 
G

Gord Dibben

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
 
J

JE McGimpsey

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.



Jolly good Delaware lad <Jolly good Delaware
 
Top