Copy & Paste formula

[bailbonds]

Hi,

When I copy a cell with formula from one workbook to another, if the formula contains links to cells in other worksheet then the paste function copies the formula with those same original links.

i.e
Original formula in workbook "Maths1" =('test1'!a1/'test2'!a1).

I then want this exact formula in another workbook "Maths2" but it copies it as -

=(['Maths1.xls]test1'a1/['Maths1.xls]test2'a1)

How can I paste it so it just does --> =('test1'!a1/'test2'!a1)

Thanks

 

[bailbonds]

Super - Thanks for your help.