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

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" wrote in message ...

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

Thanks Ron


--
xin
------------------------------------------------------------------------
xin's Profile: http://www.excelforum.com/member.php...o&userid=30939
View this thread: http://www.excelforum.com/showthread...hreadid=506128