Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table causing buffer overflow
Hi Alex,
May be you should have a look into your pivotcache and its size ... HTH Cheers Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table causing buffer overflow
how do I go bout doing this ?
best regards, Alexandre Brisebois |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added and deleted. | Excel Discussion (Misc queries) | |||
Buffer Overflow in Excel | Excel Worksheet Functions | |||
Reading txt file into the buffer | Excel Programming | |||
buffer overflow | Excel Programming | |||
Emptying the copy buffer | Excel Programming |