You can open a pivot table sheet, select PivotChart Analyze at the top, and select Refresh to update the data. You can also expand Change Data Source , pick a different database (table), and ...

Step 1: Prepare your data. Perhaps the most important step in using Excel pivot tables is to carefully organize your data. The easiest way to do this is to use Excel tables, which let you add rows ...