Episode 295 - XLS in Data Query

This is a fairly wild concept. Sometimes you want to link to an external Excel file, but you run into the limit that your formula can not refer to more than 10,000 cells in the external file. As an alternative, use Microsoft Query to retrieve records from the closed Excel file. Episode 295 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!