Hi all,

Here is my problem;

I have two workbooks: MCDAnalysis.xls and MCDHistory.xls

I am pulling data from the MCDHistory workbook to MCDAnalysis, as you can see below, using paste link.

='C:\Documents and Settings\Bodem 96\My Documents\Course Material\Acct 480 - AIS\AIS Project\[MCDHistory.xls]Balance Sheet'!B10

When I move the MCDHistory workbook from" C:\Documents and Settings\Bodem 96\My Documents\Course Material\Acct 480 - AIS\AIS Project\ "to ,say, my desktop, I am getting an error message stating that the source of links cannot be found when I open MCDAnalysis workbook. I know it is normal to get this error message.

What I need to know is this:
Is there any way to keep the links active in my MCDAnalysis workbook even when a user moves the MCDAnalysis to a different folder or a drive?

I know that I can update the source document's location from the edit-links menu option, but I need excel to do this on its own.

You all probably got the idea.

Thanks everyone