Links and references do not update when cell changes

[scastro]

Hello, this is probably easy, but as a beginner I didn't manage to find a solution for it.

I have a Sheet with 2 columns. Column B get its values from an INDIRECT reference to the first row in column B in another Sheet. This value also contains a hyperlink to the value in Sheet2.

I would like the values in column B Sheet1 to change every time the values in the reference cells (in Sheet2) get updated or modified. I don't know why, but the values don't get updated, not even when I save the file. It sometimes gets updated, after a very long time which I cannot understand.

Is there a way to make the cells in colB Sheet1 updated automatically whenever column B in Sheet2 is updated? I show below how the formulas are built for a more clear example:

Sheet1
-------
ColA ColB
Sheet2 =INDIRECT("'"&A2&"'!"&"B2")

Sheet2
-------
ColA ColB
120 none

As I said, ColB in Sheet1 also contains a link to ColB Sheet2.

Many thanks,
Sandra

 

[Andrew Poulsom]

For me in Excel 2000 your formula that uses INDIRECT updates if the referenced cell changes. Are you sure that calculation is set to automatic (Tools|Options|Calculation tab)?

 

[scastro]

That was indeed the reason. The automatic calculation was unset. Thanks a lot.
Sandra

For me in Excel 2000 your formula that uses INDIRECT updates if the referenced cell changes. Are you sure that calculation is set to automatic (Tools|Options|Calculation tab)?