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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
