Pivot Table refresh in VBA code not working

C

Carlos

Hi,
I'm getting an error when I try to refresh a pivot table that was created
using VBA code in Excel 2000. This the error: "Refresh method of pivot table
class failed".

Here is the piece of code:
Set ptCache.Recordset = rst
With wsSheet
Set ptTable = .PivotTables("Test")
End With
'Refresh Data.
ptTable.RefreshTable

Initially when I get the recordset and create the pivot table, every is
populated correctly. But when I need to run the refreshing code to get new
data into the pivot table, the refreshtable fail.

Any suggestion?
I will appreciate that.

Thanks,
Carlos.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change SourceName on Pivot Table 0
How to modify the sql statement on a pivot table using VBA- XL2000 1
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Pivot tables not refreshing after data source update 1
Refreshing Pivot table 1
Pivot Table - charts - default ? 0
Changing pivot table ADO recordset 0
Pivot table refresh problem 0

Top