Are you sure you are saving the workbook with calculation set to automatic?

Do so then close the workbook and re-open.

What's the calc status?


Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 14:48:01 -0800, Randy
wrote:

No sir....no macros running and nothing seems to happen when I press
F9....This is a tricky one huh!! Very strange! I am somewhat embarrassed as I
have been working with Excel and Office for many years and am pretty
efficient with Excel...This one is stumping me though!