Results 1 to 3 of 3

Thread: pivot tables and changing data

  1. #1

    pivot tables and changing data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    If yoyr original data has changed, is there a way to refresh the pivot table to update the data or do you need to make a new table?

  2. #2
    Select the pivot, Analyze>Data>Change Source Data

  3. #3
    If you work with dynamic range names or the format as table tool you do not have to Select the pivot, Analyze>Data>Change Source Data.

    You can auto refresh a pivot table by opening the visual basic editor (press ALT F11). In the project explorer in the visual basic editor double click the worksheet with the pivot table and type the following code.


    In the code below you need to change the sheet name ("Pivot") and the pivot table name ("PivotTable1") to your names.


    Private Sub Worksheet_Calculate()


    Sheets("Pivot").PivotTables("PivotTable1").RefreshTable

    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •