Thread
:
Worksheets with OFFSET command always ask if I want to SAVE
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
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
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben