X
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
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