Waiting for PivotTable Auto Refresh got old, so I built a VBA tool that keeps them updated on my terms.
If you've ever managed a weekly report that lives inside an Excel pivot table, you know the rather cumbersome drill. You refresh the data, the pivot updates, and then you spend the next 20 minutes ...