software

I want to use the same formula in another workbook e.g. A1 sheet2!b1, however
when I copy it it links to the other workbook e.g. when I paste I get
[otherworkbook]'a1 Sheet2!B1

How can I copy just the formula so it works in the same cells in my new
workbook

Try copying from the formula bar and pasting into the formula bar.

See wrote:
gt;
gt; I want to use the same formula in another workbook e.g. A1 sheet2!b1, however
gt; when I copy it it links to the other workbook e.g. when I paste I get
gt; [otherworkbook]'a1 Sheet2!B1
gt;
gt; How can I copy just the formula so it works in the same cells in my new
gt; workbook

--

Dave Peterson

If you're only copying one formula, you can copy it out of the formula line
(not sure what it's official name is--the area above the worksheet) instead
of copying and pasting the cell itself. Just make sure to paste the formula
into the formula line as well.

Obviously, this will be cumbersome if you've got a lot of copying and
pasting to do. So, if that's the case, do all your copying and pasting
(don't worry about the workbook references), then do a find/replace to
eliminate all references to [otherworkbook].

quot;Seequot; wrote:

gt; I want to use the same formula in another workbook e.g. A1 sheet2!b1, however
gt; when I copy it it links to the other workbook e.g. when I paste I get
gt; [otherworkbook]'a1 Sheet2!B1
gt;
gt; How can I copy just the formula so it works in the same cells in my new
gt; workbook

One other method if needing to copy multiple formulas.

In source workbook select your range of formulas.

Editgt;Replace

what: =

with: xxx=

Replace all.

Copy these amended formulas to the target workbook and reverse the editgt;replace.

Close the source workbook without saving or reverse the editgt;replace there also.

I prefer the close/no saveGord Dibben MS Excel MVP

On Fri, 27 Jan 2006 08:12:03 -0800, BekkiM gt;
wrote:

gt;If you're only copying one formula, you can copy it out of the formula line
gt;(not sure what it's official name is--the area above the worksheet) instead
gt;of copying and pasting the cell itself. Just make sure to paste the formula
gt;into the formula line as well.
gt;
gt;Obviously, this will be cumbersome if you've got a lot of copying and
gt;pasting to do. So, if that's the case, do all your copying and pasting
gt;(don't worry about the workbook references), then do a find/replace to
gt;eliminate all references to [otherworkbook].
gt;
gt;quot;Seequot; wrote:
gt;
gt;gt; I want to use the same formula in another workbook e.g. A1 sheet2!b1, however
gt;gt; when I copy it it links to the other workbook e.g. when I paste I get
gt;gt; [otherworkbook]'a1 Sheet2!B1
gt;gt;
gt;gt; How can I copy just the formula so it works in the same cells in my new
gt;gt; workbook