Links and references do not update when cell changes

scastro

New Member
Joined
May 20, 2010
Messages
10
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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

New Member
Joined
May 20, 2010
Messages
10
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)?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,193
Messages
5,768,765
Members
425,492
Latest member
blueexcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top