| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
FInding external link
When I open a spreadsheet, I get asked if I want to update external links. There
shouldn't be external links in this spreadsheet, so I must have accidentally left in a formula which I need to change to a value. But I can't find the offending cell. How do I search for a formula with an external link in it? -- Thanks, Fred |
|
#2
|
|||
|
|||
|
Hi Fred,
Try Bill Manville's FindLinks addin which is freely downloadable at: http://www.oaltd.co.uk/MVP/Default.htm --- Regards, Norman "Fred Smith" wrote in message ... When I open a spreadsheet, I get asked if I want to update external links. There shouldn't be external links in this spreadsheet, so I must have accidentally left in a formula which I need to change to a value. But I can't find the offending cell. How do I search for a formula with an external link in it? -- Thanks, Fred |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a cell value as the filename in an external link? | Excel Discussion (Misc queries) | |||
| How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
| Find a link to an external file | Excel Discussion (Misc queries) | |||
| External link using calculated cell value | Excel Worksheet Functions | |||
| Save External Link Values | Excel Discussion (Misc queries) | |||
Linear Mode
