It gets better. Open the Pivot Table Wizard in a new workbook, choose
External Data Source, select Excel as the data source, point to the workbook
containing the data, follow the wizard. You end up with a Pivot Table linked
to an external workbook. No need to open the data workbook.

Ed Ferrero