Waiting for PivotTable Auto Refresh got old, so I built a VBA tool that keeps them updated on my terms.
You don't need complex formulas to summarize thousands of rows when PivotTables can do the heavy lifting for you.