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

If you've ever managed a weekly report that lives inside an Excel pivot table, you know the rather cumbersome drill. You refresh the data, the pivot updates, and then you spend the next 20 minutes ...