Worksheets with OFFSET command always ask if I want to SAVE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

On Exit, always asked to save 3
Why do certain worksheets ALWAYS ask if I want to save them when closing them? 5
Word always asks if I want to save 2
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET 6
When you hit Save on a template, how can you save as worksheet? 1
Excel 2007 worksheet to WEB page 3
i want to assign a cell to save a worksheet 2
Windows XP SAVE AS Command 0

Back
Top