| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A Linking Problem | New Users to Excel | |||
| problem with linking data | Excel Worksheet Functions | |||
| I am stumped on a linking problem... | Excel Discussion (Misc queries) | |||
| Worksheet Linking problem | Excel Discussion (Misc queries) | |||
| linking problem with closed documents | Excel Worksheet Functions | |||
Hybrid Mode
