Microsoft announces personalized enhancements to PivotTables functions for Excel

2 min. read

Published onMay 15, 2017

published onMay 15, 2017

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Microsoft’s Office Apps have become so utilitarian and appliance-like in the enterprise work sector that the thought of personalizing an Excel document can easily be laughed away as the fever dream of an overworked data analysis.

However, Microsoft’s Office team did just that this week; they came bearing the gift of personalized default layouts in the form of PivotTables.

“As part of this month’s update, a new Excel feature gives you the ability to personalize the default layout for your PivotTables. Enabling users to personalize the PivotTable defaults started as a feature request in our Excel UserVoice forum. Now, when you’re building complex reports or performing one-off analyses, you can quickly get started with your favorite PivotTable layout. This feature is available for Excel 2016 on Windows as part of an Office 365 subscription.”

Users will now have the option to choose between two adjustment layout settings when applying their PivotTable defaults. The first option is the most streamlined for anyone wanting to try out the new PivotTable by simply clicking the newly added Edit Default Layout option in the menus settings. The second option is to import a layout a previously saved PivotTable in a preexisting workbook.

The Office team is adding tips for experimenting with OLAP PivotTables. Users canvisit the Office Blogorthe support pageto find out how to take advantage of the performance improvements this new update brings over previous Excel releases.

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

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#

Microsoft announces personalized enhancements to PivotTables functions for Excel#

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

Microsoft announces personalized enhancements to PivotTables functions for Excel