Pivot Tables

/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 [...]

 Pivot Tables And Grouping Dates

 Pivot Tables and grouping dates I use a pivot table to summarise a sales transaction data base. I want the data summarised by month. When I use the date to summarise the totals are by day rather than month. Is there a way to get totals by month? By Neale Blackwood There are two [...]

Pivot Tables|

 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, [...]

Pivot Tables|

 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 [...]

Pivot Tables|