Pivot Tables and Productivity

My favourite tweet in yesterday’s Excel Twitter collection was this one:

  • I feel like I know JUST enough about pivot tables to make all of my tasks 30 times harder #Excel #productivity #tcot

Does that ever happen to you? Maybe it’s not pivot tables – it could be another one of Excel’s powerful, but frustrating features.

You start a workbook, then add a bit of code, or a fancy formula, and things suddenly go south. So, you try to troubleshoot the problem, wander over to Google for some research, and before you know it, an hour has passed. Oop! There goes your productivity.

Pivot Table Articles

But, if pivot tables are your problem, I’ve published a couple of articles this week that might help you out.

Block (All) Selections

On my Excel Pivot Tables blog, there is sample code that prevents people from selecting the “(All)” option in a report filter drop down. That can be useful if you’ve got worksheet formulas or links that depend on one item being selected.

Here’s the link to that article: Block Selection of All in Report Filter

vbablockall03

List Pivot Formulas

And on my Contextures Blog, you can find sample code that lets you list all the pivot formulas in the active workbook (calculated items and calculated fields).

Here is the link to that one:  List All Pivot Table Formulas

pivotformulaslist

________________

2 thoughts on “Pivot Tables and Productivity”

  1. I have purchased ebooks & Excel files (for Excel 2007 and later). It was paid through Paypal and I received an e-mail asking me to confirm my purchase and give Contextures permission to give me a link to download.
    I can’t seem to find where do I go to download the pdf file. I have downloaded the files that go with the project, but as of today, I still don’t know where to go download the ebook.
    Please help.

    Thank You

    Raymond

    1. Hi Raymond,
      Thank you for buying the ebook and files, and I’ll send you an email that explains where the ebook is.
      Debra

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.