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

See wrote:

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

--

Dave Peterson