Hello,

I have two spreadsheets. test1.xls, test2.xls

test2.xls sheet1 A1=[test1.xls]Sheet1!$A$1
When I use copy and paste to B1,C1...
I got
B1=[test1.xls]Sheet1!$A$1
C1=[test1.xls]Sheet1!$A$1...

If sheet1 A1=Sheet2!A1 then I use copy and paste to B1,C1...(same spreadsheet)
I got
B1=Sheet2!B1
C1=Sheet2!C1

How can I make the first one work?

Thanks