Why do we add formulas outside Pivot Tables? Because we think Pivot Table cannot do the calculation. Did you ever check if it can?
Or did you just ASSUME?
Here is your chance to find out!
Estimated reading time 10 min
Continue reading Add formulas OUTSIDE Pivot Tables = Inefficiency
I created this Paste as Pivot utility (macro) along with Raj Chaudhuri. It helps you in copying cells from Pivot Table and pasting them as GetPivotData functions. You must read this article about GetPivotData in order to understand the background information.
Estimated reading time 8 min
Continue reading Paste as Pivot – New way to use Pivot table data
Pivot Table is based upon the current block of data.Sooner or later you are going to update the data.
Creating a table eliminates the need for refreshing the new range manually.
Estimated reading time 4 min.
Continue reading Best Practice: Always create a Table before creating Pivot Table