I am working in a large workbook that should have no external links. However, for one reason or another, there is one link that still shows up. This causes an error to pop up every time the workbook is opened. When trying to break the link, nothing happens and it still remains. Is there another way to break this link? Or a way to search the workbook for the cell that is linked? Please help!
thanks
Next time you open the WB, take note of what the link is, then do a search for that in all sheets
Also, check that there isnt perhaps a chart or a range that is still linked?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks. I did a search and it finds nothing!
You might have a named range which is referring to some other workbook - use Formulas | Name Manager to check, and delete if necessary.
Hope this helps.
Pete
Both great ideas, still hasn't solved the problem.
Any other suggestions?
Try this code
Please Login or Register to view this content.
How to use:
Open Excel.
Alt + F11 to open the VBE.
Insert | Module.
Paste the code there.
Close the VBE (Alt + Q or press the X in the top-right corner).
Test the code:
Tools | Macro | Macros...
Select BreakLinks and press Run.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=215
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks