View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
Conan Kelly
 
Posts: n/a
Default ReCalc'ing for almost everything I do

Gord,

Thanks for all the help,

Conan



"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Conan

Volatile Functions.....................

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()


Gord Dibben MS Excel MVP

On Tue, 4 Apr 2006 15:08:23 -0700, "Conan Kelly" <CTBarbarin at msn dot com
wrote:

Is OFFSET a volitile function?

Where can I find a list of volitile functions? I looked through the help files and didn't find anything.

Thanks again for all y'alls help.


"Niek Otten" wrote in message ...
Hi Conan,

You probably have one or more calls to Volatile functions in your workbook.
That could be NOW(), TODAY() or any of many more, or a User Defined Function (UDF) that was explicitly made Volatile.

--
Kind regards,

Niek Otten

"Conan Kelly" <CTBarbarin at msn dot com wrote in message ...
Hello all,

This seems like a recent phenomenon. It seems like Excel is recalculating for every insignificant action I make: Inserting
Rows, Renaming the sheet tab, Etc...

I don't remember this as being normal. It is quite annoying. Does anyone know what might be going on? Any way I can fix it?

Thanks for any help anyone can provide,

Conan Kelly