I have two Excel files: file1 with two Sheets (Sheet1 and Sheet2) and file2 with Sheet3.
Sheets 1 and 3 have the same structure but different data.
Sheet2 contains some formulas referring to Sheet1 like for example "=Sheet1!A1".
I want to copy Sheet2 to file2 with the same formulas referring to Sheet3, but when I try to copy it, formulas change from "=Sheet1!A1" to "=[file1.xls]Sheet1!A1".
How can I copy the whole sheet with the same formulas?