Forum Discussion

Elana_Scott's avatar
Elana_Scott
Copper Contributor
Jul 18, 2019

Excel Edit links

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

Formulas and Functions

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jul 22, 2019
    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.

Resources