| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding Links
I have a workbook that, when opened, generates the usual dialogue box about
updating automatic links to other workbooks. When I go to Edit/Links, 2 source files are shown. How do I find the cells in which these links are contained? I have tried searching each worksheet using "!" in formulas. I want to delete the links. I have a workbook called findlink.xla which I have obviously downloaded at some stage. When I open this (with the other workbook open) I get the usual message about Macros but then nothing further happens. No Macro is then available to run. What am I doing wrong?! Many thanks. |
|
#2
|
|||
|
|||
|
Many add-ins add a toolbar to your menu, Terry. See if there's not an
additional menu under Tools. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Terry Bennett" wrote in message ... I have a workbook that, when opened, generates the usual dialogue box about updating automatic links to other workbooks. When I go to Edit/Links, 2 source files are shown. How do I find the cells in which these links are contained? I have tried searching each worksheet using "!" in formulas. I want to delete the links. I have a workbook called findlink.xla which I have obviously downloaded at some stage. When I open this (with the other workbook open) I get the usual message about Macros but then nothing further happens. No Macro is then available to run. What am I doing wrong?! Many thanks. |
|
#3
|
|||
|
|||
|
The macro should be in a choice in the tools menu.
-- Regards, Tom Ogilvy "Terry Bennett" wrote in message ... I have a workbook that, when opened, generates the usual dialogue box about updating automatic links to other workbooks. When I go to Edit/Links, 2 source files are shown. How do I find the cells in which these links are contained? I have tried searching each worksheet using "!" in formulas. I want to delete the links. I have a workbook called findlink.xla which I have obviously downloaded at some stage. When I open this (with the other workbook open) I get the usual message about Macros but then nothing further happens. No Macro is then available to run. What am I doing wrong?! Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding links | Excel Discussion (Misc queries) | |||
| Cut links between worksheets in same workbook | Excel Worksheet Functions | |||
| Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
| Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
