Microsoft is tweaking its Excel product to bring customers faster PivotTables on OLAP servers. According to a post issued today, July 7, 2016, on the Office Blogs, customers should see improvements to their PivotTables due to some caching improvements, thanks to the Office team.
More to the point, the updates, which are being made to Office 365 subscribers, for now, include the following details on exactly what and how the improvements benefit customers directly.
Also, the Office team walks customers through how they can tweak their PivotTables to squeeze even more performance out of the tool while working with larger data environments. Apparently, adjusting or disabling the subtotals and grand totals of pivots will also lead to an additional boost in performance. Visit the Office Blogs to see the easy step-by-step process that helps increase the effective speed of PivotTables in the latest update for Excel 2016.