Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel.
You might expect that pivot tables—which can be used to summarize rows and columns of data into a digestible “number”—would automatically refresh when the data within changes. Charts already do that, for example. But, until now, a pivot table can still require a manual click to update if changes are made… and you might not always remember to make that click, either.
Microsoft says that’s changing. Within the Beta Channel (Version 2506 Build 19008.2000 or higher), Microsoft is adding an “Auto Refresh” function for pivot tables. “With Auto Refresh enabled, any updates to the source range—like new sales entries or corrections—are instantly reflected in the PivotTable, keeping it