I have a worksheet in which I had some links to a workseet in another file, but even though I have deleted them all (as far as I can tell, as I can't find any now) when I open the first sheet it still tells me I have links to the second one and asks me whether I want to update them. How can I ensure that all links have been removed to stop this?
Results 1 to 3 of 3
Thread: Missing links (Excel 2000)
-
4 Star Lounger
- Join Date
- Feb 2001
- Location
- Australia
- Posts
- 503
- Thanks
- 11
- Thanked 0 Times in 0 Posts
2005-07-07 09:40Missing links (Excel 2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2005-07-07 10:17Re: Missing links (Excel 2000)
First see if you can find out what links there are in Edit | Links... If that doesn't help, you can download Bill Manville's free FindLink utility from The Excel MVP Page. You can use this to trace all links, and break them if you want to.
-
4 Star Lounger
- Join Date
- Feb 2001
- Location
- Australia
- Posts
- 503
- Thanks
- 11
- Thanked 0 Times in 0 Posts
2005-07-07 18:33Re: Missing links (Excel 2000)
The add-in did the trick; thanks again, Hans.
