Pivot Tables collisions or can be a real problem. A meeting is coming up in a few minutes and suddenly your beautifully crafted Pivot Table dashboard report that’s been working so well for months just doesn’t update and won’t tell you why or where the problem is.
Update 11/08/21 I received an email from Clem who has written an awesome Add-In called Ribbon Icons which looks like below, to address the painful process I whinge about below for choosing and adding icons to your custom ribbon. I just can’t believe someone has nailed the solution to this horrible process a) you can …
My Custom Ribbon using Formulas to Create XML code Read More »
I recently worked on a project that had three distinct and large datasets for different geographical areas in three workbooks. Starting with the first workbook and data set in a Table in its own worksheet, I created a worksheet of seven Pivot Tables to provide seven Pivot Charts needed in their own sheet. This could …
I have blogged before about how much I love INDEX (INDEX what’s the Big Deal ). It’s powerful, nimble (non volatile so easy on performance load) and just makes so much sense to me given we are working with a grid and INDEX essentially returns the contents from the co-ordinates of the grid reference entered. …
Using INDEX to calculate a moving average dynamically Read More »