External Workbook Data Connection Option

%3CLINGO-SUB%20id%3D%22lingo-sub-2307751%22%20slang%3D%22en-US%22%3EExternal%20Workbook%20Data%20Connection%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2307751%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20way%20to%20have%20a%20worksheet%20from%20two%20separate%20workbooks%20to%20connect%20to%20a%20third%20workbook%20I%20am%20using.%20One%20would%20say%20to%20use%20Power%20Query%20(Get%20%26amp%3B%20Transform%20Data)%20but%20it%20is%20way%20too%20slow.%20Especially%20if%20those%20files%20are%20.xlsb.%20Another%20option%20would%20be%20to%20use%20a%20cell%20reference%20to%20the%20file.%20But%20that%20would%20then%20require%20opening%20the%20files%20to%20update%20the%20data%20which%20would%20be%20counter-intuitive.%20Any%20other%20ideas%3F%20Go!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2307751%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I need a way to have a worksheet from two separate workbooks to connect to a third workbook I am using. One would say to use Power Query (Get & Transform Data) but it is way too slow. Especially if those files are .xlsb. Another option would be to use a cell reference to the file. But that would then require opening the files to update the data which would be counter-intuitive. Any other ideas? Go!

0 Replies