Share this article
Latest news
With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low
Copilot in Outlook will generate personalized themes for you to customize the app
Microsoft will raise the price of its 365 Suite to include AI capabilities
Death Stranding Director’s Cut is now Xbox X|S at a huge discount
Outlook will let users create custom account icons so they can tell their accounts apart easier
Excel 2016 getting faster OLAP PivotTables in June 2016 update
2 min. read
Published onJuly 7, 2016
published onJuly 7, 2016
Share this article
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
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 seeimprovements to their PivotTablesdue 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.
About the improvements
We have made significant improvements in three major areas while querying OLAP servers.
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.
Kareem Anderson
Networking & Security Specialist
Kareem is a journalist from the bay area, now living in Florida. His passion for technology and content creation drives are unmatched, driving him to create well-researched articles and incredible YouTube videos.
He is always on the lookout for everything new about Microsoft, focusing on making easy-to-understand content and breaking down complex topics related to networking, Azure, cloud computing, and security.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Kareem Anderson
Networking & Security Specialist
He is a journalist from the bay area, now living in Florida. He breaks down complex topics related to networking, Azure, cloud computing, and security
