Excel 2007 Pivot Table Data

Back

About MrExcel

Consulting Services

Learn Excel Resources

Challenge of the Month

Data Files for Pivot Table Data Crunching for Excel 2007

Thanks for buying Pivot Table Data Crunching for Excel 2007! Mike Alexander and I used a new dataset for this book in order to show off the 1.1 million rows. The files below are the data files used when creating the book. In many cases, the files are similar from chapter to chapter. The files are saved as an Excel 2007 file using the final, Release-To-Manufacturing version of Excel 2007. If you have a version of beta 1 or beta 2, this file may not open in your version of Excel.

Right-click any link and choose Save Target As:

Click here to download the sample file used in most chapters. This should be the dataset used in Chapters 1, 2,
PT2007Intro.zip is the dataset used in both case studies in the Introduction.
PT2007Chap3.zip contains the dataset for Figure 3.1 through 3.24
PT2007Chap3a.zip contains the dataset for Figure 3.25 through 3.33 and 3.43 through 3.49.
PT2007Chap3StdDev.zip contains the dataset from Figure 3.29.
PT2007Chap3b.zip contains the dataset for Figure 3.34 through 3.41.
PT2007Chap3Index.zip contains the dataset from Figure 3.42.
PT2007Chap4.zip contains the dataset from Figure 4.1 through 4.07
PT2007Chap4Group2Dates.zip contains the dataset from Figure 4.8
PT2007Chap4GroupNumerics.zip contains the dataset from Figures 4.9 - 4.10
PT2007Chap4GroupText.zip contains the dataset from Figures 4.11 - 4.18
PT2007Chap4Sorting.zip contains the dataset from Figures 4.19 - 4.40
PT2007Chap5Case.zip contains Chapter 5 Case Study
PT2007Chap7.zip contains the dataset from Chapter 7
PT2007Chap7DB.zip contains the Access database from Chapter 7 (updated 12/10/2007)
PT2007Chap8.zip contains a legacy Excel file that supported interactivity
Click here to download the VBA macros from chapter 11.

Or, download All Files (73MB).

If you have questions about any topic in the book, you can send them to the authors, or post to the Mr Excel Board.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.