Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

PivotTable Tools ->Options ->Refresh Refresh the PivotTable A PivotTable is a report. This report displays the information from another spreadsheet. In this sample, the data is on the OriginalData sheet.   Say you added a new record to the OriginalData. How would you update the PivotTable?   8. Refresh the PivotTable Go to the OriginalData spreadsheet Copy and Paste the last row of data. You should have added one more Bug Report for Microsoft Word.