Pivot Tables - refresh from Userform command button

[Roger on Excel]

[Excel 2003]

I have a question regarding the activation of pivot table refreshes from a
userform.

I tried to use the following code in a command button without success:

ActiveSheet.PivotTables("PovotTableName").RefreshTable

I think the code doesnt work because the userform is in another
sheet to the pivot table, however I need this to be the case since I have 10
different sheets, each with a different pivot table.

Can anyone help ?

 

[john]

Roger,
Always worth looking in the VBA helpfile which gives good direction on both
questions.

Try following & see if helps:

Application.DisplayAlerts = False

Sheets("Piviot").PivotTables("PivotTable1").RefreshTable

Application.DisplayAlerts = True

 

[Roger on Excel]

Thanks John,

The code works very nicely,

All the best,

Roger

Roger,
Always worth looking in the VBA helpfile which gives good direction on both
questions.

Try following & see if helps:

Application.DisplayAlerts = False

Sheets("Piviot").PivotTables("PivotTable1").RefreshTable

Application.DisplayAlerts = True
--
jb

[Excel 2003]

I have a question regarding the activation of pivot table refreshes from a
userform.

I tried to use the following code in a command button without success:

ActiveSheet.PivotTables("PovotTableName").RefreshTable

I think the code doesnt work because the userform is in another
sheet to the pivot table, however I need this to be the case since I have 10
different sheets, each with a different pivot table.

Can anyone help ?