+ Reply to Thread
Results 1 to 2 of 2

Refresh a Single Pivot Table Only?

  1. #1
    Registered User
    Join Date
    08-31-2006
    Location
    Humboldt Park, Chicago
    MS-Off Ver
    Office 365 MSO (16.0.12430.20198) 64-bit
    Posts
    33

    Refresh a Single Pivot Table Only?

    I have Excel 2013 through an Office 365 subscription.

    I created a copy of a pivot table in the same tab so I could compare some results between different teams. I want to refresh only one of the pivot table but when I click refresh, every pivot table on every tab refreshes with it. It make no difference whether I right-click refresh within the target PVT, or I go to Pivottable Tools/Analyze/Data and take care to select "Refresh" rather than "Refresh All".

    Is 2013 hardwired to only refresh every pivot table in a workbook?

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Refresh a Single Pivot Table Only?

    Try...
    Refresh every pivot tables on the Sheet1.
    Please Login or Register  to view this content.
    Refresh pivot table named PivotTable1 on the Sheet1.
    Please Login or Register  to view this content.
    Last edited by HerryMarkowitz; 09-14-2014 at 05:33 PM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

+ 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. Replies: 6
    Last Post: 02-23-2024, 02:11 PM
  2. Refresh all pivot tables upon change of data in a single cell
    By KAC1979 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-12-2013, 02:21 PM
  3. Replies: 0
    Last Post: 08-14-2013, 06:31 AM
  4. [SOLVED] Using VBA to change a pivot table filter, refresh the report and set up a refresh delay
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2012, 10:43 AM
  5. Replies: 2
    Last Post: 10-25-2010, 11:31 AM

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