Unsolved
This post is more than 5 years old
2.1K Posts
0
6635
Finding Links in Excel
Running Excel 2000.
I have one workbook that whenever I open it, it informs me that "The workbook contains automatic links to info in another workbook".
And of course gives me the option to update or keep existing info.
I have searched through the worksheets and cannot find anything linked to another workbook.
How can I find what these links are so that I might sever them?
I have one workbook that whenever I open it, it informs me that "The workbook contains automatic links to info in another workbook".
And of course gives me the option to update or keep existing info.
I have searched through the worksheets and cannot find anything linked to another workbook.
How can I find what these links are so that I might sever them?
RoHe
10 Elder
10 Elder
•
43.5K Posts
0
April 20th, 2008 21:00
Ron
Jim Hardin
2.1K Posts
0
April 20th, 2008 22:00
But thanks!
Bay Wolf
4.4K Posts
0
April 21st, 2008 01:00
I'm not sure that it is this way in Excel 2000, but here is how to look at them on Excel 2003.
With the workbook open, go to Edit > links.
There you can view what it is linked to and break the link if you want to.
Edit: I can across this link that you may want to check out.
How to remove links from a worksheet in Excel 2000
To change the link source, follow these steps:
Select the Edit, Links command.
In the Links dialog box, select the source workbook that you want to change.
Click the Change Source button.
In the Change Links dialog box, select a new source file and then click OK.
Jim Hardin
2.1K Posts
0
April 21st, 2008 09:00
A global search revealed the link in a formula that was in a hidden row!