Waiting for PivotTable Auto Refresh got old, so I built a VBA tool that keeps them updated on my terms.
Microsoft Excel has been wrong about the same date for 40 years, and that's by design.