I notice that your link formula as shown does not include the path.
That is the form that the formula would have when the source file is
open. If you prepend the path to the workbook it should work when the
source file is closed:
='C:\MyDir\[07-05ApprovedAPSourcingDecisionsWithSQData.xls]Charts by
CommData'!$B15

Does that help?

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