In Chapter 9, "Using External Data Sources for Your Pivot Table," you will learn the process of getting to external data with MS Query and how to use external data in your pivot tables. You'll learn how to use external data to avoid some of Excel's row limitations, as well as how to create dynamic pivot table reporting systems. |