Learn Excel Episode 295: XLS in Data Query

Posted in Companies, Podcasts on July 02, 2008


Learn Excel 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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel