How to merge Excel workbooks and keep references to an external one

Hi,

I have 130 Excel workbooks. They are all made of one worksheet. The worksheets have the same name.

Each workbook has references (or links) to a another workbook containing fixed data.

I would like to merge these 130 workbooks into one.

When I use Data > Get Data > From File > From Folder, all the cells are flatted. The links are lost.

I would like to keep the links in the merge workbook.

Is there a way to make it?

Thanks for your reply and your help,

Sincerely,

Hi Ali,

thanks for your reply.

Sure.

Sincerely.