No. That did not work. This is so frustrating? I cannot believe that
a newer version of Excel would complicate work.

I have the entire path
='C:\Metrics\Sourcing\APSourcing\Distribution\2005 \MonthlySourcing\[08-05ApprovedAPSourcingDecisionsWithSQData.xls]Charts
by CommData'!$B$8 and if I copy/paste it I am prompted to select the
location of the file by a popup window.

Any other suggestions??

Thanks!