Leading the way in Microsoft Office Development

Knowledge Base Articles - 2003

820742 - 2003: Description of the limits of PivotTable reports in Excel

287080 - 2003: Error Messages When You Add Dimensions to PivotTable Report

816562 - 2003: How to change connection information for a query in Excel

Knowledge Base Articles - 2002

317782 - 2002: 'Error -2147417848' Occurs When Data Fields Are Added to a PivotTable from VBA

819853 - 2002: 'Unable to read file' error message when you open Excel file that contains a PivotTable report

284885 - 2002: Data Selection Is Not Updated in PivotTable Report After Changes Are Made to Data Source Query

325207 - 2002: Edits to PivotTables Do Not Bring Back New Columns

286510 - 2002: Excel Uses Microsoft OLE DB Provider for OLAP Services 8.0 for All OLAP Queries

307809 - 2002: Excel stops responding when you drag an item in the PivotTable Layout wizard

299303 - 2002: GETPIVOTDATA Function Displays #REF! Error If External Reference Is Closed

316446 - 2002: The file that contains a PivotTable grows each time that it is saved

816997 - 2002: Time Calculation in Pivot Table May Not Be Accurate

284870 - 2002: When You Create a Reference to a Custom Subtotal in PivotTable #REF! Is Returned

Knowledge Base Articles - 2000

236091 - 2000: 'Cannot connect to the data source...' Error Refreshing OLAP PivotTable

213955 - 2000: 'PivotTable Field Name Is Not Valid...' Error Message When Refreshing Creating PivotTable Report

214349 - 2000: 'Reference Is Not Valid' Error Message When You Create PivotTable

215965 - 2000: 12:00:00 AM Displayed for Dates Earlier Than 1900

207526 - 2000: Blanks Sorted Differently in Office PivotTable List

259587 - 2000: Calculated Member Is Not Displayed in PivotTable

210737 - 2000: Cannot Change PivotChart Source Range

283838 - 2000: Cannot Expand PivotTable If Data Is Not Saved with Table

287079 - 2000: Cannot See Cubes Created in SQL 2000 Server Analysis Services

231006 - 2000: Cannot Undo PivotTable Refresh for Non-OLAP Data Sources

211912 - 2000: Cannot Use Web Data Source as PivotTable Data

234030 - 2000: Clicking 'Export to Excel' Results in Blank Excel PivotTable

210790 - 2000: Client-Server Settings Error 'Problems Obtaining Data'

316479 - 2000: Contents of PivotTable Disappear When Data Is Updated in a Different Language Version of Excel

253846 - 2000: Crash When Removing Formatting from PivotTable

213947 - 2000: Create PivotTables from Multiple Consolidation Ranges in Excel 2000

231421 - 2000: Create a Normal Chart from a PivotTable in Excel 2000

105136 - 2000: Creating Pivot Table from External Data Hangs Computer

235537 - 2000: Custom Sort or Prevent Auto Sort in PivotTable in Excel 2000

213455 - 2000: Data Fields Are Not Included in PivotFields Collection

215961 - 2000: Data Labels on Published PivotCharts May Lose Number Formatting

214021 - 2000: Data Number Formatting Is Lost After You Create a PivotTable

210783 - 2000: DataType Property Always Returns xlNumber in OLAP PivotTables

214057 - 2000: Display Data as Percentage of the Total in a PivotTable in Excel 2000

210777 - 2000: Editing Local OLAP Cube Creates New Cube

215782 - 2000: Empty Cells in Published PivotChart and PivotTable Display Zeros

210806 - 2000: Error Accessing Data in Offline OLAP Cube

216005 - 2000: Error Clicking Export to Excel When Exporting OLAP Data

207522 - 2000: Error Loading PivotTable Containing Two Fields with Same Name

230958 - 2000: Error Message 'The cube file .cub cannot be opened for writing.'

214026 - 2000: Error Message: 'Cannot Group that Selection'

226516 - 2000: Error Message: A Field in Your Source Data Has More Unique Items...

210735 - 2000: Error Using Delete Method to Remove a Data Series from a PivotChart

256002 - 2000: Excel Crashes When You Add Calculated Field to a PivotTable

229925 - 2000: Filter Settings Lost When You Move to or from Page Field

207530 - 2000: Formatting Lost When You Publish a PivotTable

214336 - 2000: Grouping a Field in a PivotTable Changes Other PivotTable

228618 - 2000: Help Topic for Refresh Method Is Incomplete for Chart Object

213697 - 2000: How to Create PivotTable from Word

213418 - 2000: How to Obtain the SQL Statement for a PivotTable

273583 - 2000: How to optimize PivotTable performance in Excel 2000

236378 - 2000: Incorrect Classic PivotTable Format Constant Recorded in Macro

213922 - 2000: Index Data in a PivotTable in Excel 2000

248225 - 2000: Invalid Page Fault Changing PivotTable Data Source

268079 - 2000: OLAP Data in Excel PivotTable Is Incorrect

206938 - 2000: Opening Web Page Containing PivotTable Prompts for User Name and Password

210808 - 2000: Page Field Area Missing After Creating PivotTable

210752 - 2000: Parameter Names Lost When Publishing a PivotTable

288647 - 2000: Pivot Table Error Message: Cannot Show or Hide Detail for This Selection

210794 - 2000: PivotChart Button Overlaps Data Labels in Pie Chart

221245 - 2000: PivotChart Data Labels Lost When Published Interactively

215959 - 2000: PivotChart Report Loses Data When Pasted to a New Workbook

215986 - 2000: PivotTable Does Not Preserve Conditional Formatting

212141 - 2000: PivotTable Items Missing When Fields Are Pivoted

210826 - 2000: PivotTable List Grouped by Week Becomes Grouped by Month in Exported Excel PivotTable

210823 - 2000: PivotTable Printout Is Truncated in Internet Explorer

213897 - 2000: PivotTable Report Created on New Worksheet Despite Setting in Wizard

211945 - 2000: PivotTable Report Unavailable with Parameter Query

215997 - 2000: PivotTable Times Greater Than 24 Hours Displayed Incorrectly

237469 - 2000: PivotTable Updated Slowly with OLAP Data Source

214302 - 2000: PivotTable Wizard Does Not Automatically Refresh Data

213894 - 2000: Source Data for PivotTable Is Displayed As Number Signs

236331 - 2000: Supporting Data for the Initial View of Your PivotTable May Be Visible to Users

205675 - 2000: Totals Missing From PivotTable Published From Excel

199269 - 2000: Undo Unavailable After Creating PivotChart Report

213914 - 2000: Use STDEV or STDEVP with a PivotTable in Excel 2000

211908 - 2000: Use a Web Data Source for a PivotTable in Excel 2000

211949 - 2000: Use the GetPivotData Worksheet Function in Excel 2000

211515 - 2000: Using server page fields in PivotTables in Excel

211703 - 2000: Wrong Values Displayed for Calculated Item in PivotTable

221000 - 2000: XLDataSource Error Opening PivotTable Published from Excel List

210785 - 2000: Zero Values Unexpectedly Displayed in Published PivotTable List

Knowledge Base Articles - 1997

157383 - 1997: Active Cell Moves Using RefreshTable Method

163904 - 1997: Cannot Use Web Data Source as PivotTable Data

174678 - 1997: Copying Shapes Cancels Selection of Shape

119318 - 1997: Data Fields Not Included in PivotFields Collection

172279 - 1997: Error Message Appears Sorting a Field in a PivotTable

115471 - 1997: Error Message Grouping Data in PivotTable

166740 - 1997: Formula Errors Appear After Updating PivotTable

203268 - 1997: Hidden Page Fields Items No Longer Counted in PivotTable Summary

104309 - 1997: How PivotTables Differ from Version 4.0 Crosstab Tables

151551 - 1997: How to Analyze Questionnaire or Survey with a PivotTable

170745 - 1997: How to Create PivotTable from Word

142589 - 1997: How to Create PivotTables from Multiple Consolidation Ranges

156449 - 1997: How to Create a Report Template

106359 - 1997: How to Display Data as Percentage of Total in Pivot Table

151515 - 1997: How to Index Data in a PivotTable

131331 - 1997: How to Obtain the SQL Statement for a PivotTable

142153 - 1997: How to Use Grouping for Fields in a PivotTable

152984 - 1997: How to Use STDDEV or STDDEVP with a PivotTable

164020 - 1997: How to Use a Web Data Source for a PivotTable

161538 - 1997: How to Use the GetPivotData Worksheet Function

162386 - 1997: How to Use the PivotTable AutoShow Feature

156314 - 1997: How to Use the PivotTable AutoSort Feature

269619 - 1997: How to change connection information for a query in Excel 97

178164 - 1997: Illegal Operation Refreshing Data in PivotTable

207663 - 1997: Illegal Operation When You Refresh Data in PivotTable

202232 - 1997: Incorrect Field Names Appear in PivotTable Field Dialog Box

187934 - 1997: Inserted Objects on Charts Are Not Redrawn Correctly

211517 - 1997: Limits of PivotTables in Excel

104308 - 1997: Optimizing PivotTable Performance

110599 - 1997: Pivot Table Uses COUNT Instead of SUM with Blank Cells

172990 - 1997: PivotTable Appears Incorrect If Data Contains Merged Cell

168252 - 1997: PivotTable Items Missing When Fields Are Pivoted

161540 - 1997: PivotTable Report Unavailable with Parameter Query

110343 - 1997: PivotTable Source Changes From Another PivotTable

106243 - 1997: PivotTable Wizard Does Not Automatically Refresh Data

162476 - 1997: Purpose of the PivotTable Optimize Memory Option

186109 - 1997: Refreshing PivotTable Causes Excel to Quit Unexpectedly

161882 - 1997: Using PivotTable Calculated Fields and Calculated Items

157488 - 1997: Using Server Page Fields in PivotTables

172097 - 1997: Wrong Values Displayed for Calculated Item in PivotTable