Excel Weekly News from Contextures September 9, 2014

5 pivot problems + more Excel tips

In this week's Excel news, you'll see how to fix 5 annoying pivot table problems, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.

 -  Debra -  ddalgleish@contextures.com

Problem With VBA Code Debugging

If a macro doesn't run correctly, you do some troubleshooting in the Visual Basic Editor. I often use the F8 key to step through the code, one line at a time. Recently though, the F8 key didn't stop at the next line, like it was supposed to, and I finally found a solution to the problem.

Click here to see the details: Problem with F8 Key

5 Annoying Pivot Table Problems

I love pivot tables, but they do have a few problems that you might have run into. You can see my list of the 5 most annoying pivot table problems, and how to avoid them. Do you have any problems to add to the list?

Some of the problems can be fixed with my Pivot Power Premium add-in, so remember to use those features, if you've bought a copy. It can clear old items, change Count to Sum, and much more.

Click here to read the details, and watch the slide show: 5 Annoying Pivot Table Problems

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

Video: Split Prize Amounts for Ties With RANK Function

In a contest, there might be a set prize amount for the top few contestants. How would you split the prize money, if two or more people tie for one of the positions? Watch this video to see how to use the RANK function to split the prize money..

Late Summer Flowers

This is the first year that I've had a Stonecrop plant (Sedum Spectabile) in the garden, and for most of the year it just looked like a clump of broccoli, with tiny green buds on top. It has finally started to blossom, and now it's covered with hundreds of delicate pink flowers, and it's a lovely addition to the late summer garden.


Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.