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?
--
Thanks for your help.
Karen53