Thanks SO much, both of you who replied :) :) you have saved my day!

"damorrison" wrote:

I just think you may have calculations set to manual, test it out by
pressing F9 when the calculation doesn't work if this works then go to
the tools menu, calculation,set calculation to automatic
dave