Home

Excel Edit links

%3CLINGO-SUB%20id%3D%22lingo-sub-763054%22%20slang%3D%22en-US%22%3EExcel%20Edit%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763054%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20365%20financial%20reporting%20file%20that%20has%20multiple%20linked%20files.%20Every%20month%20the%20linked%20files%20are%20updated%20during%20the%20month%20and%20when%20I%20need%20to%20generate%20my%20report%2C%20I%20would%20like%20to%20be%20able%20to%20open%20all%20linked%20files%20in%20one%20click.%20Currently%2C%20I%20select%20one%20by%20one%20to%20open%20them%2C%20which%20is%20frustrating.%20Is%20there%20an%20easy%20way%20to%20select%20all%20linked%20files%20to%20open%20at%20once%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EElana%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-763054%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767513%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Edit%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767513%22%20slang%3D%22en-US%22%3EIn%20the%20Data%2C%20Edit%20links%20dialog%20you%20can%20select%20all%20files%20by%20clicking%20th%20first%20and%20shift-clicking%20the%20last.%20Then%20Open%20Source%20should%20open%20all%20of%20them.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767615%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Edit%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767615%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B.%20Such%20a%20straight%20forward%20easy%20solution.%26nbsp%3B%20Have%20a%20great%20day!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Elana_Scott
New Contributor

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 Replies
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.

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