Pivot Table(s)

Roopen

Board Regular
Joined
Apr 10, 2008
Messages
158
Hi All,

Hoping someone can help.. I have a spreadsheet that has about 5 pivots in one workbook... I am trying to find a way that if I change one of the pivots in the workbook the other pivots underneath will automatically refresh..

Is this possible or is there a macro that can do this?

Your help is always greatly appreciated

Roopen
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Xavier77

New Member
Joined
Jul 23, 2010
Messages
7
Hi Roopen,

You can create a macro to refresh all tables simultaneously.

Simply start recording the macro, refresh all tables and stop recording was all tables have been completed.

Hope this helpls

Xavier
 

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
This might be more 'universal'

Code:
Sub refreshAllPivots()
    For Each ws In ActiveWorkbook.Worksheets
        For Each pt In ws.PivotTables
            pt.PivotCache.Refresh
        Next pt
    Next ws
End Sub
 

Roopen

Board Regular
Joined
Apr 10, 2008
Messages
158
Weaver,

This is more what I was after thank you so much... Saved me doing manual recording of a macro.

Roopen
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,501
Messages
5,511,690
Members
408,859
Latest member
willm57

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top