Copying & Pasting Formula

C

Connie Martin

Everytime I copy a row of formulas and paste them into another worksheet of
another workbook, it pastes linked to the other file. How do I get the bare
formula to paste without referencing the file they came from?

Connie Martin
 
P

Peo Sjoblom

First do an edit>replace and replace the equal sign = with something like a=
then copy and paste, finally do a reverse replacement on all sheets involved
 
Top