I thought there was a way to do this in 2003 but now I'm on 2007. Is there a way to find broken links?
I thought there was a way to do this in 2003 but now I'm on 2007. Is there a way to find broken links?
I found this site. Does it help?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
In 2007, in the Data tab, Connections group, there's a Edit Links button that will show you your links (don't know if it shows all links), and allow you to open the other WB, break link, etc.
Paul
thanks Paul
Posting Permissions
Reply With Quote