I use the copy sheet to copy from sheet1 of A.xlsx to sheet1 of B.xlsx, where sheet1 of A.xlsx has the formula “=sheet2!A:B”, but now the formula of sheet1 in B.xlsx becomes “='[C:.. \A.xlsx]sheet2!A:B”
How to do I need the formula in sheet1 in B.xlsx doesn’t automatically change to the link address?
Hello @Eric.163
Did you try giving the Destination sheet name? Also can you try copy to the same excel and check whether this reference path is getting appended
I add a sample, please refer to
testCopySheet.zip (14.2 KB)