ReCalc'ing for almost everything I do

C

Conan Kelly

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
 
C

Conan Kelly

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.
 
G

Gord Dibben

Conan

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

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


Gord Dibben MS Excel MVP
 
C

Conan Kelly

Gord,

Thanks for all the help,

Conan



Gord Dibben said:
Conan

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

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


Gord Dibben MS Excel MVP
Click to expand...
 
G

Gord Dibben

Thanks Peo

Can't even recollect from where I got that list of functions.

Misguided once more<g>


Gord

That list is not entirely correct, rows() and columns() are not volatile
Click to expand...

Gord Dibben MS Excel MVP
 
P

Peo Sjoblom

I believe that list is originally from MS btw AREA is not volatile either
and INDEX was volatile pre 97 but not anymore. INFO is missing from that
list but it is volatile. CELL I believe is partly volatile so the correct
list should be

OFFSET()
CELL()
INDIRECT()
INFO()
NOW()
TODAY()
RAND()



Peo
 
J

joeu2004

Gord Dibben said:
Volatile Functions.....................
[....]
RAND()
Click to expand...

Can anyone suggest a good reason why RAND()
(and RANDBETWEEN) is volatile?

It is really annoying that it is.
 
Top