Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
We're back for another informative blog in our series, Excel at Excel with Steve Hughes! In this post, he will cover how to retain the size of your PivotTable after refreshing your data.
Let’s start with the fact that these tips are the result of my work with Excel to support BI tasks. This turns out to be one of those things that power users of Excel probably already know. I had to find this out and thus I am sharing it here.
When I was working on the dashboard for Modern Apps Live! I had some nicely formatted tables. However, I had two pivot tables stacked as seen in the picture below on the right.
Whenever I did a data refresh the columns would automatically resize to the “one-inch” width. Making the Poll Questions in the second table unreadable.
I went looking for how to fix this. I searched for solutions online and I poked around to see if I could fix this problem. After all, it was very important to be able to refresh the data on the dashboard.
I was able to locate the solution here. As it turns out, you need to unselect the Autofit column widths on update property on the PivotTable. You can get to those options in a couple of ways in Excel 2013. First you can right click on the table to get the short-cut menu and select PivotTable Options.
Or you can select Options on the far left of the ANALYZE tab on the PIVOTTABLE TOOLS ribbon.
Once you are in PivotTable Options, you go to the Layout & Format tab and deselect the Autofit option as mentioned above.
Voila! Problem resolved, now my dashboard does not need the columns resized in the pivot tables each time it is refreshed.
Learn more about Excel in our 4-day online class is designed to get you up-to-speed using tools easily accessible to Power Users: Microsoft Excel and Power BI Desktop.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.