memory leak

M

MFRASER

I think I am experiencing a memory leak when I try and run the following
code:

Dim pCache As Excel.PivotCache
Dim pTable As PivotTable

Set pCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal)
Set pCache.Recordset = rst
Set pTable = pCache.CreatePivotTable(sheet.Range("A8")) 'Fails on this
line

Set AddPivotTable_Recordset = pTable


When I run the code the process never gets past the create pivot table. Are
there any limits on the size of recordset I can add to a pivot table? How
can I make sure I have the latest service pack?

I am running version 9.0.3821 SR-1 Excel 2000.
 
Top