Intersheet reference

H

hwatari

I am using a cell in another sheet in a formula, however the formula does not
update when the cell chages its value.
Is this a normal behavior of Excel ? Is there a way to update automatically ?
Thanks,
Hiromichi
 
F

Frank Kabel

Hi
check 'Tools - Options - Calculate'. Automatic calculation should be enabled
 
T

tjtjjtjt

First try:
Tools | Options | Calculation. Make sure Calculation is set to Automatic.

tj
 
Top