Copy formulae into another workbook and eliminate worksheet refer.

J

Jimbo

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.
 
D

Dirk Goldgar

Jimbo said:
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.
Click to expand...

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.
 
Top