Pivot Tables

Home/Pivot Tables

58 Crazy Excel Stories (that are probably happening in your company right now)!

  58 Crazy Excel Stories (that are probably happening in your company right now)!Crazy things happen when you mix untrained users with Excel.It’s not really rocket science.  Crazy things would happen with any complex system if you don’t train people properly.But many companies simply assume that everyone knows Excel, so they don’t need much (if any) [...]

The 3 most requested Pivot Table Features – Free

3 Bonus Pivot Buttons you really need Free Add-in By Wyn Hopkins If you’re a regular Pivot Table creator then download this free add-in to save yourself some time. There are a number of steps involved when creating a Pivot Table that are often repetitive and frustrating.  So much so I’ve created [...]

 Pivot Tables And Grouping Dates

 Pivot Tables and Grouping Dates I use a Pivot Table to summarise a sales transaction database. I want the data summarised by month. When I use the date to summarise the data, it adds all the years together. How do I fix this? If you just summarise your data into a Pivot Table, it [...]

 My Pivot Table Won’t Refresh!

My Pivot Table won't Refresh! How to Solve Problems in Protected Workbooks By Jeff Robson You may come across some interesting behaviour (aka a real "gotcha") when working with Pivot Tables and VBA Macros in protected workbooks and sheets. When working on a file where each sheet has been protected using the userinterfaceonly:=true flag, [...]

 Tips On Refreshing Pivot Tables

Tips on Refreshing Pivot Tables Speed up your Pivot Tables By Wyn Hopkins Refresh All Pivot Tables If you need a better way to quickly refresh all the Pivot Tables in your workbook, here's a short macro that'll do just that: Sub RefreshALL 'Refresh all Pivot Tables and SQL queries Activeworkbook.RefreshAll End sub Or [...]

 Analysing Tabular Data Using A Pivot Table

Analysing Tabular Data using a Pivot Table Sometimes our source data isn't in a format that can be readily analysed by a "normal" pivot table However, there is a trick you can try that may well save a lot of time and effort. By Wyn Hopkins For, example, the data set below gives the [...]