Pivot table causing buffer overflow

[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

 

[Carim]

Hi Alex,

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

HTH
Cheers
Carim

 

[Alexandre Brisebois]

how do I go bout doing this ?

best regards,
Alexandre Brisebois

 

[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

 

[Carim]

Alex,

If you want go even further ...
Take a look at Debra's brilliant site :
http://www.contextures.com/xlPivot11.html

HTH
Carim