VLookup & SUMIf

[Karen53]

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?

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[Karen53]

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?

--
Thanks for your help.
Karen53

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

--
---
HTH

Bob


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