I'm having multiple Excel files 'Embeeded as Object' into single excel file, I'm trying summarize by extracting / link data into one file.
My problem is I'm unable to link Object data into my worksheets. Link breaks in even of change of opening sequence of Objects.
I want that links are created as '[OBJECT1]Des'!A2 instead of '[Worksheet in Test.xlsx]Des'!A2.
Many thanks in Advance.