Excel - Pivot Table Defaults: Episode 1461

2,067 views · Published 1 November 2011 · 6:24 · Indexed 1 November 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Introducing the Ultimate Solution for Pivot Table Defaults | MrExcel Podcast.

Welcome to episode 1461 of the MrExcel podcast, where we will be discussing the common frustration of pivot table defaults. Have you ever wondered why there are chart templates, but not pivot table templates? Well, after receiving numerous requests from my seminar attendees, I decided to take matters into my own hands and create a solution. Introducing the MrExcel Labs, a collection of small programs designed to make your life easier.

In this episode, I will be sharing my progress on the new add-in that aims to solve all your pivot table annoyances. But first, I want to hear from you. What drives you crazy about pivot tables? Is it the compact view, the empty cells showing as blanks, or the incorrect formatting? Send me your ideas at [email protected] and if your suggestion is included in the add-in, you will receive a free copy upon its release.

So far, the add-in includes features such as creating pivot tables with tabular view instead of compact layout, automatically filling in item labels, and showing empty cells as zero. But the most controversial feature is the option to resize columns and carry over formatting from the original fields. I'll be discussing the pros and cons of these features and would love to hear your thoughts on them.

In this episode, I will also be giving you a sneak peek of the add-in in action. With just a click of a button, you can create a pivot table with your preferred default settings. No more wasting time changing the layout or formatting. And for just a few bucks, this add-in will save you from all the frustration and annoyance caused by pivot table defaults.

So, whether you're using Excel 2003, 2007, 2010, or even a Mac, this add-in will work for you. Just make sure to let me know your Excel version when you send in your suggestions. I am excited to hear your feedback and make this add-in the ultimate solution for all your pivot table woes. Thank you for tuning in and don't forget to subscribe to the MrExcel podcast for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Pivot Table Defaults
(00:19) Need for Pivot Table Templates
(00:51) Goal of Add-In and Request for Feedback
(01:25) Current Features of Add-In
(02:12) Demonstration of Add-In
(03:20) Controversial Features and Request for Feedback
(05:00) How to Provide Feedback and Free Copy of Add-In
(05:50) Compatibility and VBA Considerations
(06:06) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Annoyances with Pivot Tables
Applying Formatting
Carrying Formatting from Original Fields
Compact View
Default Pivot Table Format
Empty Cells Show Zero
Less Stupid Pivot Defaults
Makin' Excel Easier
MrExcel Labs
Pivot Table Template
Resizing Columns
Tabular View


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153139/


1. Why can't we do a Pivot Table Template?

2. Why can't we turn off the annoying Compact Layout?

3. Why do I keep asking these questions when it is so easy to override them with a tiny add-in?

The MrExcel Labs is coming out with a tiny add-in to solve Pivot Table Annoyances. This is your chance to weigh in with what 'Pivot Things' annoy you most and you can win a free copy of the add-in. Watch the podcast [Episode #1461] and find out all of the details!

...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

More from this channel