Troubleshooting Excel PivotTables
- Apr 7, 2006
- My Beautiful Formatting Disappeared!
- I Cannot Pivot the Report
- The Summary Function I Want is Not Available
- Response Is Slow With External Data
- Exploring Excel Functions, Part 9: Analyzing Frequency Distributions
- Exploring Excel Functions 8: Predicting the Future
- Exploring Excel's Functions, Part 7: Rounding with Excel
- Exploring Excel's Functions, Part 6: TTEST() Function
- Troubleshooting Excel PivotTables
- Exploring Excel's Functions, Part 5: The Power of Choice
- Exploring Excel's Functions, Part 4: Database Functions
- Exploring Excel's Functions Part 3: CELL() Shocked
- Exploring Excel's Functions Part 2: ADDRESS() and INDIRECT()
- Exploring Excel's Functions: IF() Only!
- Advanced Find-and-Replace Tools in Word
- Going Beyond Basic Spaces and Hyphens in Word
- Get Organized with Word's Outline Tools
- Managing Your Money in Microsoft Excel: Basic Financial Calculations
Sorry, this author hasn't posted any blogs.
Like this article? We recommend
Pivot Table Data Crunching
PivotTables make certain kinds of data analysis possible. I won’t say they make analysis simple because PivotTables are not necessarily the easiest thing to understand, and a lot of people run into problems when using them. Here are some tips for solving or working around some of the most commonly encountered problems.
My Beautiful Formatting Disappeared!
Have you ever refreshed a PivotTable or changed its layout only to see your carefully designed formatting vanish? To avoid this situation (which you cannot always avoid), do the following:
- If you are using an autoformat, make sure that the AutoFormat Table option is selected in the PivotTable Options dialog box.
- For non-autoformats, such as font and color changes, you should have the Preserve Formatting option checked (also located in the PivotTable Options dialog box).
Some formats—most notably conditional formatting and cell borders—cannot be preserved. If possible, wait until the PivotTable is in its final form before applying these formatting changes.
Account Sign In
View your cart