Try this, in the workbook with the original hyperlink formulas do
editreplace (or ctrl +h)
find what =

replace with ^=^

so replace the equals sign with a dummy text string not likely to be in any
of the formulas

select the replaced formulas which are now regular text strings, copy and
paste them into the new workbook. Finally reverse it

find what ^=^

replace with =

in both workbooks



--
Regards,

Peo Sjoblom



"WillW" wrote in message
...
I'd like to be able to copy a column of hyperlink formjula cells, e.g.,
=HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving
the formulas as they are in the original file.

The default seems to be for Excel to cleverly add a reference to the
original file into the formula, =HYPERLINK('[PIID
Worksheet-projects1.xls]P1'!$B$49,'[PIID
Worksheet-projects1.xls]P1'!$A$49)

But how can I get an exact copy of my column of formulas from one file to
another?

Thanks,
Bill