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" wrote in message
...
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