VLookup & SUMIf

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen53 - 03 Mar 2008 22:29 GMT

Hi,

I have been having trouble with my workbook behaving as if it has volatile
functions. I have checked and removed any volatile functions I had. Part of
the problem resolved. The other did not.

I have systematically removed formulas testing to see if it made any
difference. Removing VLookup seemed to make a difference so I removed it.
The problem started again.

Now it appears as though SUMIF is the culprit. Since I was getting false
positives to my testing with Vlookup, I suspect they both are.

Has anyone had any experience of knowledge of VLookup and SUMIF behaving in
a volatile fashion?

Signature

Thanks for your help.
Karen53

Reply to this Message

Bob Phillips - 03 Mar 2008 23:07 GMT

Not unless you have a volatile function such as TOADY() embedded within it.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
[quoted text clipped - 13 lines]
> in
> a volatile fashion?

Reply to this Message

Karen53 - 04 Mar 2008 00:05 GMT

Hi Bob,

I have searched the entire workbook for the following:

Cell, Offset, Today, Indirect, Now, Info, Rand

and none of them exist. I do not have any functions I have created that are
volatile.

If I open my workbook and make a change to an empty, unlinked cell, nothing
happens. If I change a cell that affects another worksheet and then change
an empty, unlinked cell, all the worksheet_calculates run. If I close the
workbook and reopen it, it stops. Until I make a change that affects another
worksheet then they all run again when I change an empty, unlinked cell.
This sheet has no worksheet change code associated with it.

I have tried putting breaks at the beginning of all my procedures. It takes
me directly into the worksheet calculates when I make the change.

I don't know what else to try to isolate what is happening. Are there any
other volatile functions I have missed?

Signature

Thanks for your help.
Karen53

> Not unless you have a volatile function such as TOADY() embedded within it.
>
[quoted text clipped - 15 lines]
> > in
> > a volatile fashion?

Reply to this Message