13. Advanced Pivot Table Tips and Techniques

Unique Solutions to Common Pivot Table Problems

In this chapter, you discover techniques that provide unique solutions to some of the more common pivot table problems. Take time to glance at the topics covered here. Who knows? You might find a few unique tips that can help you tackle some of your pivot table conundrums!

Tip 1: Force Pivot Tables to Refresh Automatically

In some situations, you might need to have your pivot tables refresh themselves automatically. For instance, suppose you created a pivot table report for your manager. You might not be able to trust that he will refresh the pivot table when needed.

You can force ...

Get Pivot Table Data Crunching: Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.