Grouping PivotTable Data by Week

I must admit, my Excel use has declined significantly since returning to school full-time. But, I still find plenty of uses – and, because they are not my routine office tasks, sometimes they are more interesting and I have more to write about. This one comes from a project I am helping a family member […]

Avoid the Dread GETPIVOTDATA

  It has a purpose, but GetPivotData has confused and frustrated many Excel users. You want to write a formula using PivotTable cells and get a clunky, inflexible result. Here’s how to stop it.  Click anywhere inside your PivotTable, then select Analyze, Options, and uncheck “Generate GetPivotData.”