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…