Uploaded January 2015 | Updated September 2026, 6 minutes ago

---

Get the Excel file here: http://1drv.ms/1bYwrTa
Creativity is essential when creating Excel solutions.
In this video see how a formula tells you that a pivot refresh is necessary (or that pivot is already refreshed).
An array formula can do this. Of course it won't work for complex pivots but the concept is interesting.

twitter.com/KevinLehrbass
myspreadsheetlab.com