Hosted on MSN

The Excel feature I've been waiting a year for still hasn't arrived, so I built it myself

One of the easiest ways to make an Excel report unreliable is to forget one tiny step: refreshing the PivotTables behind it. Microsoft recognized the problem and announced Auto Refresh a year ago, but ...

Added sales but they don't appear in the PivotTable? | Checking the source data range in Excel

I added new rows to my monthly sales data and clicked "Refresh" in the PivotTable. Yet, the added month doesn't appear in the ...