Automatic refresh of pivot table on changes in external data source.

**namrata773** · 12-04-2013, 02:27 AM

Hi,
I have a pivot table report connected to an external data source (OLAP cube).I want to automatically refresh the pivot table report everytime the OLAP cube data changes.

I know we can use Automatic refresh on open of workbook or time intervals after which to refresh .But i want the auto refresh to work even if the workbook is already open and there is no definite time interval after which the cube is likely to change.SO,by defining intervals for auto refresh i do not intend to waste time refreshing even if there is no change.

There are multiple pivot table reports and pivot charts connected to the same OLAP cube.

Is it possible through some macros and if so can anyone share the same.I have no knowledge of writing macros for Excel.

Thanks.

**NeedForExcel** · 12-04-2013, 04:43 AM

Can you attach your sample workbook? I will help you with the code.

You can use something like

Sub RefreshPT()

Dim PT As PivotTable
Dim WS As Worksheet

    For Each WS In ThisWorkbook.Worksheets

        For Each PT In WS.PivotTables
          PT.RefreshTable
        Next PT

    Next WS

End Sub

Deep

Automatic refresh of pivot table on changes in external data source.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Automatic refresh of pivot table on changes in external data source.

Re: Automatic refresh of pivot table on changes in external data source.

Thread Information

Users Browsing this Thread

Similar Threads

Two pivot table under one source data, how to specifically refresh one pivot table ONLY?

Macro to refresh pivot table and update data source

[SOLVED] Auto Refresh Pivot Table Once External Data source Changes

Excel 2007 : Pivot table from protected external data source

Pivot Table external XLS file source change and GETPIVOTDATA refresh

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions