Finding links
Hi,
I've got a workbook with various links into it (as shown via Edit, Links...). However, I cannot find the cells that are linked. Can anyone show me an easy way of finding them out? Thanks, Will |
Does this help http://j-walk.com/ss/excel/usertips/tip054.htm
-- Message posted via http://www.officekb.com |
Thanks. Interesting - but it doesn't help me in this instance.
Will ""VoG via OfficeKB.com"" wrote: Does this help http://j-walk.com/ss/excel/usertips/tip054.htm -- Message posted via http://www.officekb.com |
Try Bill Manville's Find Link on Stephen Bullen's MVP page
http://www.oaltd.co.uk/MVP/Default.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "will" wrote in message ... Thanks. Interesting - but it doesn't help me in this instance. Will ""VoG via OfficeKB.com"" wrote: Does this help http://j-walk.com/ss/excel/usertips/tip054.htm -- Message posted via http://www.officekb.com |
Sometimes links can be workbook names that do not reference cells in the
active workbook. Check Insert - Name - Define and look for references to other workbooks. |
Look at the find/ replace video clip on
http://www.auditexcel.co.za/othertools.html "will" wrote: Hi, I've got a workbook with various links into it (as shown via Edit, Links...). However, I cannot find the cells that are linked. Can anyone show me an easy way of finding them out? Thanks, Will |
Thanks for the link to the "Find Link" file, I have been unable to locate
lost links for a long time now, and this file sorted it in a matter of minutes. Dave G "David McRitchie" wrote in message ... Try Bill Manville's Find Link on Stephen Bullen's MVP page http://www.oaltd.co.uk/MVP/Default.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "will" wrote in message ... Thanks. Interesting - but it doesn't help me in this instance. Will ""VoG via OfficeKB.com"" wrote: Does this help http://j-walk.com/ss/excel/usertips/tip054.htm -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 07:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com