There is a formular on the cell, simply referring to another cell on a
different sheet and do some calculation. Somehow it doesn't do it
automatically and showing 0, until I click on the cell, then click on
formular cell on toolbar then click on the sheet again. Now the value appears.

Does anyone know what's the problem? Is there any simple command to refresh
all the values on a worksheet?

strout

Tools - Options - calculation - set calculation to automatic

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help


"strout" wrote in message
...
There is a formular on the cell, simply referring to another cell on a
different sheet and do some calculation. Somehow it doesn't do it
automatically and showing 0, until I click on the cell, then click on
formular cell on toolbar then click on the sheet again. Now the value
appears.

Does anyone know what's the problem? Is there any simple command to
refresh
all the values on a worksheet?

strout