Bob Mc wrote:
What I'd like to
have is relative OLE links, where the OLE links refer to the instance of the
Excel spreadsheet residing in the new directory. I realize that I can
"update" the links to the new instance of the spreadsheet, but wondered if
there was a way to save this step.


Thanks for the clear explanation.
I am not aware of a way to do this.
Sorry.

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