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

 

[xin]

Thanks Ron