Please turn JavaScript on

Excel Pivot Tables

Want to keep yourself up to date with the latest news from Excel Pivot Tables?

Subscribe using the "Follow" button below and we provide you with customized updates, via topic or tag, that get delivered to your email address, your smartphone or on your dedicated news page on Specificfeeds.

You can unsubscribe at any time painlessly.

Title of Excel Pivot Tables: "Excel Pivot Tables - Tutorials by www.contextures.com"

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.11 / week

Message History

In an Excel pivot table, if you try to group a date or number field, you might see an error message. The message box shows a yellow warning label, and the text says, “Cannot group that selection”. Error Message Troubleshooting There are 2 common causes for...
Read full story
After you sort an Excel pivot table, the wrong item might appear at the top of a column. For example, in the screen shot below, the list of Sales Rep names has Jan at the top. Below that name, all the other names are sorted in the correct alphabetical orde...
Read full story
Do you ever make a quick pivot table, then spend the next 30 minutes trying to make it look good? Here are three quick pivot table layout tips, to make your job a bit easier! 1) Make the Numbers Fit Last week, I increased the font size on a worksheet, and ...
Read full story
If you have a report filter at the top of your pivot table, do the items in the drop down list ever appear out of order? That happens in my pivot tables occasionally, and there isn’t a quick and easy way to fix the problem! Video: Sort Pivot Table Report F...
Read full story
After you create an Excel pivot table, the source data usually changes. New records are added, and old records might be changed or deleted. Later, when you refresh the pivot table, you should see a summary of your updated data, but sometimes there’s a prob...
Read full story