Excel 2003 Links Paths not including drive

I have an Excel 2003 Spreadsheet which reference other add-ins. The add-ins are installed in the same location in all PCs at C:\program files\MyPlugins\ Now I moved the spreadsheet to a Network Drive P:

When I try to open the spreadsheet from the P: drive it is giving me an errors that it can't find the add-ins. I looked in the Links and it is now looking at P:\program files\MyPlugins\ and obviously can't find it.

I believe somehow the spreadsheet is using relative paths instead of including the full path and the drive letter.

Any ideas how to fix th开发者_运维问答is?

This is a common issue when moving or emailing files.

If its only a few links in one file then you can remap them manually from P:\ to C:\ via Edit - Links

For lots of files a utility is the way to go. You can use Bill Manville's LinkManager, available here to re-map from your UNC path.

I wrote something about that problem, 2 years ago. It's in French, but the formulae are in English, and you can have it automatically translated for what it's worth...