When you say the links are corrupted what do you actually see? Is this a case of the path no longer being valid or is there something else going wrong.



You could change your options to not automatically update the links when you open the document and set the links for manual updates. Then you will only need to update the links when something in your Excel file changes.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

The file is already set to manual updates. And the file path is correct.

when I right click on the table, I only see 'object' as an option. Not the usual items to refresh the link. When I go through to the links they have the correct file path, but do not recognise it. Both files are on the same server and in the same folder...