I just noticed that you also mentioned "links" as well as cell
references. It does help  to put the "link" references into
variables, and use range  names in those variables, if that fits.
When the data  from which the formula is using is also in the new
workbork, as long as it has the same range name, it will check the
range on the new workbook, if it's coded that way. I have to do
that in the programming that I've been doing, so if that's the case,
let me know and I'll give you the steps--assuming that what I've
already suggested doesn't answer your question.

As always, I have to add another vote of confidence about this
group--heheh, where I miss, others see. After all, this is where I
learned.