| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Linked Workbooks/Sheets
Hi,
Would be greatfull if someone can help. I have a large work book with severals limked workbooks attached to it. I can see the names of all the linked workbooks by going to the Edit--Links menu command. I need to find out exactly how the sheet I am intrsted in(the source sheet) to this destination sheet--i.e which coulmns in the Destination wokbook is linked to coulmns in the Source work book. The destination workbook contains numerous cells with links, fomulas in them, so going to each cell and looking at the Formula bar for the link is not an option... Thanks Raj |
|
#2
|
|||
|
|||
|
Linked Workbooks/Sheets
You can toggle between viewing cell values and cell formulas by pressing Ctrl
+ ` (grave accent). "RAJ" wrote: Hi, Would be greatfull if someone can help. I have a large work book with severals limked workbooks attached to it. I can see the names of all the linked workbooks by going to the Edit--Links menu command. I need to find out exactly how the sheet I am intrsted in(the source sheet) to this destination sheet--i.e which coulmns in the Destination wokbook is linked to coulmns in the Source work book. The destination workbook contains numerous cells with links, fomulas in them, so going to each cell and looking at the Formula bar for the link is not an option... Thanks Raj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie & linked wordksheets = mass confusion | Excel Discussion (Misc queries) | |||
| Linked files don't work after upgrade | Excel Discussion (Misc queries) | |||
| How do I automatically open linked documents in Excel? | New Users to Excel | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| Linked worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
