Pivot table causing buffer overflow

  • Thread starter Thread starter Alexandre Brisebois
  • Start date Start date
A

Alexandre Brisebois

I am currently using excel 2000.

I was given a previously built spread sheet, and was told to add 2
columns
tothe data, when I do so all my pivots are fine except one. This new
pivot loads
properly through the wizard, but when I try to update the data I get a
memory location read error. (buffer over flow)

has anyone ever experienced something like this? any known solutions?

best regards,
Alexandre Brisebois
 
Hi Alex,

May be you should have a look into your pivotcache and its size ...

HTH
Cheers
Carim
 
Something like :
Sub Test()
Dim ws As Worksheet
Dim pt As PivotTable
Set ws = ActiveSheet
Set pt = ws.PivotTables(1)
MsgBox "Pivot table cache memory is currently " & _
Format$(pt.PivotCache.MemoryUsed, "#,##0") & " bytes."
End Sub

HTH
Carim
 
Back
Top