![]() |
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 |
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 |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com