I seem to remember someone else remarking on links to workbooks
generated by a non-Excel package having problems like this.

If you open the new Inventory.xls in Excel and save and close it, does
the dashboard workbook then update OK? If so, I suspect the generating
software is not creating a workbook in quite the correct format for
Excel to link to.

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