Problems copying a formula between worksheets

[xin]

I have two worksheets. Let's call them Book1 and Book2.

In cell A1 of Sheet1 of Book1, I have the following formula:=Sheet2!A1.
When I copy this formula to Book2, the formula changes to:=[Book1]Sheet2!A1.

Is there a way to copy this formula from Book1 to Book2 and have it remain:=Sheet2!A1?

Thanks

[Ron de Bruin]

Hi xin

You can use replace for this to make text of the formulas

Select the cells
Edit replace
Change = (equal sign) to $$$$$= (unique string).

Copy paste

Use Edit replace now to change $$$$$= to = to make formulas






--
Regards Ron de Bruin
http://www.rondebruin.nl


"xin" <[email protected]> wrote in message news:[email protected]...
>
> I have two worksheets. Let's call them Book1 and Book2.
>
> In cell A1 of Sheet1 of Book1, I have the following
> formula:=Sheet2!A1.
> When I copy this formula to Book2, the formula changes
> to:=[Book1]Sheet2!A1.
>
> Is there a way to copy this formula from Book1 to Book2 and have it
> remain:=Sheet2!A1?
>
> Thanks
>
>
> --
> xin
> ------------------------------------------------------------------------
> xin's Profile: http://www.excelforum.com/member.php...o&userid=30939
> View this thread: http://www.excelforum.com/showthread...hreadid=506128
>

[xin]

Thanks Ron