Linking Problem in Excel
 

My Excel work book contains multiple sheets linked to main sheet.The links
are working but they are not taking the values in linked cells.E.g., if cell
C1 is linked with Sheet!B2 ..upon dubble clicking C1,it jumps to the link
Sheet!B2 but C1 should also display value of Sheet!B2..that unfortunately it
is not doing.
If Sheet!B2 has "200" then C1 should also show "200"?right...it is not ..it
is showing zero..pls help

Linking Problem in Excel
 

I'd check the calculation mode:

Tools|Options|calculation tab

Make sure it's set to automatic.

Double M wrote:

My Excel work book contains multiple sheets linked to main sheet.The links
are working but they are not taking the values in linked cells.E.g., if cell
C1 is linked with Sheet!B2 ..upon dubble clicking C1,it jumps to the link
Sheet!B2 but C1 should also display value of Sheet!B2..that unfortunately it
is not doing.
If Sheet!B2 has "200" then C1 should also show "200"?right...it is not ..it
is showing zero..pls help

--

Dave Peterson