If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
find linked cells?
Is there a way to automatically find all links in cells
where they are linked to another workbook? Not just Edit - Links to see which workbook, but to actually find the cells either one by one or all at once automatically. I know Edit Find - [ will work but there must be a better way? Want to look at over 100 workbooks and find their links and investigate any problem links etc. Ta Sall |
#2
|
|||
|
|||
find linked cells?
Sallyt wrote:
Is there a way to automatically find all links in cells where they are linked to another workbook? Not just Edit - Links to see which workbook, but to actually find the cells either one by one or all at once automatically. I know Edit Find - [ will work but there must be a better way? FINDLINK.XLA from http://www.BMSLtd.ie/mvp will find the links in an individual open workbook. I also have a utility (LinkManager) which will scan all workbooks in a directory - email me at Bill_Manville @ compuserve.com (without the spaces) if you want a copy. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
find linked cells?
Very many thanks Bill. Just wanted to know whether you
could do it without any extra downloads. Thanks for replying! Sally T -----Original Message----- Sallyt wrote: Is there a way to automatically find all links in cells where they are linked to another workbook? Not just Edit - Links to see which workbook, but to actually find the cells either one by one or all at once automatically. I know Edit Find - [ will work but there must be a better way? FINDLINK.XLA from http://www.BMSLtd.ie/mvp will find the links in an individual open workbook. I also have a utility (LinkManager) which will scan all workbooks in a directory - email me at Bill_Manville @ compuserve.com (without the spaces) if you want a copy. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup . |
Thread Tools | |
Display Modes | |
|
|