Hi ExcelMonkey,

Check that calculation is set to manual

Should, of course, be:

Check that calculation is NOT set to manual


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi ExcelMonkey,

Check that calculation is set to manual and that your macro is not
resetting the calculation mode.

---
Regards,
Norman



"ExcelMonkey" wrote in message
...

Sorry Jan, I am not sure if I was clear enough. My point is that my
Excel function is not updating when it should and I cannot figure out
why. It updates only when I go into the formula bar and hit enter. If
I calc the sheet or workbook, it does not update.

EM


--
ExcelMonkey
------------------------------------------------------------------------
ExcelMonkey's Profile:
http://www.excelforum.com/member.php...fo&userid=5221
View this thread:
http://www.excelforum.com/showthread...hreadid=267551