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
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
________________
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
Hi Raymond,
Thank you for buying the ebook and files, and I’ll send you an email that explains where the ebook is.
Debra