Inquisitive1 wrote:
='C:\Metrics\Sourcing\APSourcing\Distribution\2005 \MonthlySourcing\
[08-05ApprovedAPSourcingDecisionsWithSQData.xls]Charts by CommData'!$B$8

This path is rather long (130 characters).
I wonder if that is somehow the root of the problem.

Try an experiment with the source file in C:\Temp and see if the problem persists

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup