Copying & Pasting Formula

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

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

--

Regards,

Peo Sjoblom


"Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
news:D46AF157-9799-48D0-BAE5-D1E8C2BC8FB7@microsoft.com...
> 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
>

Hey! Now that's cool! Thank you for such a clever idea!

Connie Martin

"Peo Sjoblom" wrote:

> 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
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
> news:D46AF157-9799-48D0-BAE5-D1E8C2BC8FB7@microsoft.com...
> > 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
> >
>
>
>