software

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: www.excelforum.com/member.php...oamp;userid=30939
View this thread: www.excelforum.com/showthread...hreadid=506128Hi 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
www.rondebruin.nlquot;xinquot; gt; wrote in message ...
gt;
gt; I have two worksheets. Let's call them Book1 and Book2.
gt;
gt; In cell A1 of Sheet1 of Book1, I have the following
gt; formula:=Sheet2!A1.
gt; When I copy this formula to Book2, the formula changes
gt; to:=[Book1]Sheet2!A1.
gt;
gt; Is there a way to copy this formula from Book1 to Book2 and have it
gt; remain:=Sheet2!A1?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; xin
gt; ------------------------------------------------------------------------
gt; xin's Profile: www.excelforum.com/member.php...oamp;userid=30939
gt; View this thread: www.excelforum.com/showthread...hreadid=506128
gt;

Thanks Ron--
xin
------------------------------------------------------------------------
xin's Profile: www.excelforum.com/member.php...oamp;userid=30939
View this thread: www.excelforum.com/showthread...hreadid=506128