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