Cate wrote:
Or
is to update the links in the older file the "proper" way to do it?


Sorry I misunderstood you.
I think you have the right solution.

In general I would only recommend not updating links when you know you
have up to date information (or you don't care!) - and when updating
takes a long time becaues of the number and nature of the formulas.

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