+ Reply to Thread
Results 1 to 4 of 4

If Pivot table refreshes automatically?

  1. #1
    Registered User
    Join Date
    07-09-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1

    If Pivot table refreshes automatically?

    Is there a way to set up a pivot table so that it automatically refreshes when data is changed?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: If Pivot table refreshes automatically?

    No, unless you used VBA for it.

    I can't help you (enough) with the solution in VBA.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: If Pivot table refreshes automatically?

    Here ii one VBA option:-

    Please Login or Register  to view this content.
    Put this code in each sheet (in the VBA window) that have Pivot Tables.
    The code will run every time you click the sheet tab.

    Regards

    peterrc

  4. #4
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: If Pivot table refreshes automatically?

    Here ii one VBA option:-

    Please Login or Register  to view this content.
    Put this code in each sheet (in the VBA window) that have Pivot Tables.
    The code will run every time you click the sheet tab to open the sheet..

    Regards

    peterrc

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro that refreshes pivot tables
    By Sgligori in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2015, 11:16 PM
  2. Automatically Update Table from Pivot Table
    By toci in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2015, 03:58 PM
  3. Auto-Refresh Pivot Table When Source Data Refreshes
    By XLINT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2015, 11:00 AM
  4. [SOLVED] Select item of a dropdown list (data validation) and refreshes values of all pivot tables
    By siroco79 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 03-06-2014, 05:35 AM
  5. [SOLVED] Pivot table doesn't refreshes
    By pic2pic in forum Excel General
    Replies: 4
    Last Post: 01-20-2013, 05:27 AM
  6. Help to calculate % automatically in Pivot Table
    By cyberuser in forum Excel General
    Replies: 6
    Last Post: 01-12-2011, 12:55 PM
  7. Stopping cells from automatically refreshing after external data refreshes
    By UNWATCHABLE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2010, 11:36 PM

Bookmarks

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