+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - Auto Refresh

  1. #1
    Registered User
    Join Date
    Denver, CO

    Pivot Table - Auto Refresh

    MrExcel.com was kind enough to provide some code to include in the tab to execute an auto refresh on a pivot table. However, I am not smart enough to implement the code.

    I have three tabs in my workbook.

    - Raw Data sheet (the source data)
    - Calculations (a sheet that has calculations of the raw data. This is the sheet that is the source data for the pivot .)
    - Summary (the sheet with the pivot table)

    Here is MrExcel's code:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Application.EnableEvents = True
    End Sub

    I was told to view code in the Raw Data tab and insert this code and when the data in the Raw Data tab changed it would automatically update the pivot table in the Summary tab.

    It isn't working. I am sure it is "pilot error" on my part. HELP! WHAT AM I DOING WRONG?



  2. #2
    Registered User
    Join Date
    A simple way to make pivot tables automatically refresh is to right click on them, and choose table options, then check the box for an automatic refresh and set the frequency!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1