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

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

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

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

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

That list is not entirely correct, rows() and columns() are not volatile


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"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

Thanks Peo

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

Misguided once more<g


Gord

On Tue, 4 Apr 2006 16:01:23 -0700, "Peo Sjoblom"
wrote:

That list is not entirely correct, rows() and columns() are not volatile

Gord Dibben MS Excel MVP

"Gord Dibben" wrote:
Volatile Functions.....................
[....]
RAND()

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

It is really annoying that it is.

For a test, I opened up an old spreadsheet that has a lot of "volatile"
formulas (ones that change every time the spreadsheet calculates.) In this
case, they were formulas using the Indirect function like so:

=SUMPRODUCT(--(INDIRECT("'Wk" & H$5&
"'!$C$6:$C$1673")=$A8),--(INDIRECT("'Wk" & H$5 &
"'!$D$6:$D$1673")<""),--(INDIRECT("'Wk" & H$5 &
"'!$L$6:$L$1673")<12),--(INDIRECT("'Wk" & H$5 & "'!$L$6:$L$1673")=10))

When I edited this worksheet for the new year, I got rid of all traces of
these formulas because I got sick of watching it calculate every time I did
the least little thing. When I opened the spreadsheet just now, I tried
something that as far as I know, should not have caused a calculation, I
inserted a brand new sheet, and was going to rename it but before I did that,
I noticed it was calculating away. So my guess is you have a significant
number of volatile formulas. Just to complete the story, I changed the above
formulas to something like this:

=SUMPRODUCT(--('Wk1-2'!$D$6:$D$1673=$C5),--('Wk1-2'!$L$6:$L$1673<12),--('Wk1-2'!$L$6:$L$1673=10))
--
Kevin Vaughn


"Conan Kelly" wrote:

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