Hello all.
I'm trying to refresh PivotTables from a macro, using the folowing code:
Sheets("PTable").PivotTables("PivotTable1").RefreshTable
When I step through the macro (using F8), this line executes fine and refreshes the PivotTable successfully. However, when I run the macro from a button on the sheet, the PivotTable does not get refreshed.
Any ideas? I'm stumped.
Thanks.
This message was edited by Arvi on 2002-05-13 09:54
I'm trying to refresh PivotTables from a macro, using the folowing code:
Sheets("PTable").PivotTables("PivotTable1").RefreshTable
When I step through the macro (using F8), this line executes fine and refreshes the PivotTable successfully. However, when I run the macro from a button on the sheet, the PivotTable does not get refreshed.
Any ideas? I'm stumped.
Thanks.
This message was edited by Arvi on 2002-05-13 09:54