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
|