miatch
07-03-2009, 01:56 AM
I'm trying to update my pivot-tables with a macro,how can I avoid error400? here is my code:
Sub RefreshPivotTables()
Dim pivotTable As pivotTable
For Each pivotTable In ActiveSheet.PivotTables
pivotTable.RefreshTable
Next
End Sub
Can anybody help me with that?
Sub RefreshPivotTables()
Dim pivotTable As pivotTable
For Each pivotTable In ActiveSheet.PivotTables
pivotTable.RefreshTable
Next
End Sub
Can anybody help me with that?