Excel Edit links

[Elana_Scott]

I have an Excel 365 financial reporting file that has multiple linked files. Every month the linked files are updated during the month and when I need to generate my report, I would like to be able to open all linked files in one click. Currently, I select one by one to open them, which is frustrating. Is there an easy way to select all linked files to open at once? 

Thank you,

Elana

[#2]

In the Data, Edit links dialog you can select all files by clicking th first and shift-clicking the last. Then Open Source should open all of them.

[#3]

Thank you so much @Jan Karel Pieterse . Such a straight forward easy solution.  Have a great day!