Thread: Working with Pivot Tables

Hi, I'm not new to Excel, however, I've never worked with Pivot Tables and I need some assistance. I'm using an excel file that was created and used for an event last year. So, I'm guessing I delete all information in the source sheet, but it's not clearing the info on the Pivot Table. Can I delete the info there as well?? If I change the info in the source table, how do I get it to update the pivot table??

You must "Refresh" the Pivot Table by:

1) Right-click in your Pivot Table (borders turn blue) and click on "! Refresh", OR
2) Do View\Toolbars and select PivotTable. You can drag this toolbar using the vertical bar on the left edge. I like to dock it to the right of the Drawing toolbar on the bottom because it fits nicely there. Then hit the "!" tool to refresh.

Pivot table data is stored in some memory called a Pivot Cache and is not updated unless you refresh. That's why it didn't clear...

Thank you DogLips for the help. I did as you said and it worked! Thanks a million!!