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