Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Microsoft Knowledgebase Articles

XL2000: Data Fields Are Not Included in PivotFields Collection (213455)
When you run a macro that uses the PivotFields collection to return fields in a PivotTable, fields in the data area are not returned

XL: How to Change Connection Information for a Query (269619)
After you change the folder location or server name of a database that a query or PivotTable is using, you cannot manually change the connection information to the new folder or server.

XL2000: Cannot Set the Orientation Property of a Pivot Field (318063)
An error message occurs when you try to set the Orientation property of a field that contains more than 8,000 unique values.

XL: How to Obtain the SQL Statement for a PivotTable (131331)
Use the SourceData property to determine a Pivot Table's data source.

XL2000:Incorrect Classic PivotTable Format Constant Recorded in Macro (236378)
If you format your PivotTable with the PivotTable Classic AutoFormat, the macro recorder adds an invalid constant .

XL2000:Problems Using Code to Display ChartWizard on PivotTables (218986)
You may receive an error message, if you attempt to use code to display the Chart Wizard dialog box for a PivotChart


Pivot Table Programming Links

Advanced Spreadsheet Programming with Microsoft Excel 97
This paper includes programmatic manipulation of PivotTable objects and the PivotTable cache

Microsoft Office XP PivotTable Component Object Model
The object model diagrams show how the objects in an object model fit together.

Working with PivotTable and PivotChart Reports
Introduces the basics of PivotTable reports, then describes how to build and control them by using VBA.


Excel Programming Books with Pivot Table Information

The following books contain some information on Pivot Table programming, usually limited to one chapter.

Excel 2002 Power Programming with VBA; John Walkenbach; Hungry Minds Inc; ISBN: 0764547992 ; US$49.99

Excel 2002 VBA Programmers Reference; John Green, Stephen Bullen, Rob Bovey, Robert Rosenberg; 993 pages; Wrox Press Inc; ISBN 1861005709; US$39.99

Writing Excel Macros; Steve Roman; 529 pages; O'Reilly & Associates; ISBN: 1565925874; US$29.95

Microsoft Excel 2002 Visual Basic for Applications Step by Step; Reed Jacobson; 336 pages + CDROM; Microsoft Press; ISBN 0735613591 US$39.99

 

Intro | Pivot Tables | Pivot Charts | Programming Pivots (links only) | Pivot Links