Pivot table causing buffer overflow
 

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

Pivot table causing buffer overflow
 

Hi Alex,

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

HTH
Cheers
Carim

Pivot table causing buffer overflow
 

how do I go bout doing this ?

best regards,
Alexandre Brisebois

Pivot table causing buffer overflow
 

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

Pivot table causing buffer overflow
 

Alex,

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

HTH
Carim