Copy formulae into another workbook and eliminate worksheet refer.

[Guest]

I want to copy a formula from one workbook that has links to worksheets
within that workbook to another workbook that has the same named worksheets.
When I do this, the formula contains the origin spreadsheet as a reference
and does not allow use of the formula for the current workbook.

 

[Dirk Goldgar]

I want to copy a formula from one workbook that has links to
worksheets within that workbook to another workbook that has the same
named worksheets. When I do this, the formula contains the origin
spreadsheet as a reference and does not allow use of the formula for
the current workbook.

I think this is a question that would be better asked in one of the
Excel newsgroups, rather than this one, which is devoted to general
questions about Microsoft Access, the database product.