For once I am able to pass on a tip rather than sponge off other people’s knowlege.
Being an accountant that uses Excel for accounts many of my excel files contain external links to last years files, which I have to delete when preparing the next years accounts.
I am delighted to find that the delete links wizard (http://support.microsoft.com/kb/188449), written for Excel 97 seems to works perfectly in Excel 2007
David