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...
