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