Linking Problem in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I'd check the calculation mode:

Tools|Options|calculation tab

Make sure it's set to automatic.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct in Excel 2003 3
Drop Down with dynamic named range offsheet source list 14
link data from multiple workheets 3
Dependent drop down dynamic range formula, off sheet. 7
linked formula on multiple sheets 1
Challenging Formula. Need help with writing a formula 3
Link to same cell in different sheets 4
Payment calculation 1

Back
Top