How do I delete the refernce a formula when copying and pasting?
 

When I copy from one workbook to another, the reference is copied. How do I
delete
the reference part of all my formulas on a sheet? Example:

='[4trial 2008 Wkly Summary.xlsx]WklyInfoA868'!D23

I just want: =WklyInfo868!D23 to show up in the cell. I need this
to occur
for all the formulas copied on this sheet.

Suggestions!

How do I delete the refernce a formula when copying and pasting?
 

In target workbook EditLinks and change source to target workbook.

Another easy method is to do an editreplace in the source sheet.

Replace what: =

Replace with: ^^^

Replace all.

Copy the range over to target workbook then reverse the process in both
books or just in target book and close source book without saving.


Gord Dibben MS Excel MVP

On Wed, 23 Jul 2008 14:08:00 -0700, Lora
wrote:

When I copy from one workbook to another, the reference is copied. How do I
delete
the reference part of all my formulas on a sheet? Example:

='[4trial 2008 Wkly Summary.xlsx]WklyInfoA868'!D23

I just want: =WklyInfo868!D23 to show up in the cell. I need this
to occur
for all the formulas copied on this sheet.

Suggestions!