Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Somehow one of my workbooks thinks it has links to another workbook. Maybe
something got established accidentally, I don't know. My workbook has 150 sheets though, and I don't really want to search for the unwanted link one cell at a time. Is there some way to ask Excel to tell me precisely *which* cells it thinks are linked to another workbook? Thanks. Bill |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can click on on EDIT in the menu and select LINKS to get the names of the
files. Once you have the names of the files you can search through each worksheet using FIND, just make sure that LOOK IN is set to FORMULAS. -- Kevin Backmann "Bill Martin" wrote: Somehow one of my workbooks thinks it has links to another workbook. Maybe something got established accidentally, I don't know. My workbook has 150 sheets though, and I don't really want to search for the unwanted link one cell at a time. Is there some way to ask Excel to tell me precisely *which* cells it thinks are linked to another workbook? Thanks. Bill |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I use the fine Add-in from Bill Manville called "Find Links" for such as this.
http://www.bmsltd.ie/MVP/Default.htm Vaya con Dios, Chuck, CABGx3 "Bill Martin" wrote: Somehow one of my workbooks thinks it has links to another workbook. Maybe something got established accidentally, I don't know. My workbook has 150 sheets though, and I don't really want to search for the unwanted link one cell at a time. Is there some way to ask Excel to tell me precisely *which* cells it thinks are linked to another workbook? Thanks. Bill |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
That is a marvelous solution! My problem turned out to be one button somehow
linked to a now deleted back level version of the workbook. I'd never have found it manually searching through all the pages. Thanks Chuck. Bill --------------------- CLR wrote: I use the fine Add-in from Bill Manville called "Find Links" for such as this. http://www.bmsltd.ie/MVP/Default.htm Vaya con Dios, Chuck, CABGx3 "Bill Martin" wrote: Somehow one of my workbooks thinks it has links to another workbook. Maybe something got established accidentally, I don't know. My workbook has 150 sheets though, and I don't really want to search for the unwanted link one cell at a time. Is there some way to ask Excel to tell me precisely *which* cells it thinks are linked to another workbook? Thanks. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Broken Links | Excel Discussion (Misc queries) | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) | |||
How to find links to another workbook? | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |