Using data from Multiple Objects

Copper Contributor

Hi,

 

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.

0 Replies