Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: Finding external "links" in a spreasheet
People send me spreadsheets to copy dat into a master spreadsheet. Since
there is a mix of formulas and linked data, I want to identfy exactly what cells have links, and then I want to remove selected links. Does anyone know how to identify what cells have the links, without investigating each and every cell? Thanks! |
#2
|
|||
|
|||
Until Excel gets a native find links feature.............
Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site. http://www.oaltd.co.uk/Default.htm Click on link to MVP's With this add-in you can find and delete links if any exist. Gord Dibben Excel MVP On Sat, 15 Oct 2005 09:22:29 -0700, "CILeader" wrote: People send me spreadsheets to copy dat into a master spreadsheet. Since there is a mix of formulas and linked data, I want to identfy exactly what cells have links, and then I want to remove selected links. Does anyone know how to identify what cells have the links, without investigating each and every cell? Thanks! |
#3
|
|||
|
|||
Have you tried EDITLINKS and then checked out the list of external links there, or are you just talking about links to other sheets
within the same workbook? One way to find links, in addition to the external link method, is to do a find for the "!" character. There is always an exclamation point in a link formula, so that method will find them for you and take you to them one at a time. At least you don't have to go looking for them. You can also temporarily have the sheet display formulas instead of results (TOOLSOPTIONSVIEW(tab), and then check the formulas radio button). Aside from that, you could either use code to find them or you could insert columns and write a formula that will pull out the addresses or the results of precedent cells which have links, then just copy down. HTH -- RMC,CPA "CILeader" wrote in message ... People send me spreadsheets to copy dat into a master spreadsheet. Since there is a mix of formulas and linked data, I want to identfy exactly what cells have links, and then I want to remove selected links. Does anyone know how to identify what cells have the links, without investigating each and every cell? Thanks! |
#4
|
|||
|
|||
Or yes, you could use an add-in. That is great idea.
-- RMC,CPA "R. Choate" wrote in message ... Have you tried EDITLINKS and then checked out the list of external links there, or are you just talking about links to other sheets within the same workbook? One way to find links, in addition to the external link method, is to do a find for the "!" character. There is always an exclamation point in a link formula, so that method will find them for you and take you to them one at a time. At least you don't have to go looking for them. You can also temporarily have the sheet display formulas instead of results (TOOLSOPTIONSVIEW(tab), and then check the formulas radio button). Aside from that, you could either use code to find them or you could insert columns and write a formula that will pull out the addresses or the results of precedent cells which have links, then just copy down. HTH -- RMC,CPA "CILeader" wrote in message ... People send me spreadsheets to copy dat into a master spreadsheet. Since there is a mix of formulas and linked data, I want to identfy exactly what cells have links, and then I want to remove selected links. Does anyone know how to identify what cells have the links, without investigating each and every cell? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FInding external link | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
How do I use Excel to post data to an external database? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |