Results 1 to 2 of 2

Thread: .PivotTable.PivotCache.MemoryUsed takes an aweful long time on large pivots.

  1. #1
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0

    .PivotTable.PivotCache.MemoryUsed takes an aweful long time on large pivots.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Not a question but an observation, really.

    PivotTable.PivotCache.MemoryUsed takes an aweful long time on large pivots.

    Code:
    Sub test()
    Dim start As Date
     start = Now()
    Debug.Print "MemoryUsed: " & ActiveCell.PivotTable.PivotCache.MemoryUsed / 1000 & "kB"
    Debug.Print "Time Taken: " & Format(Now() - start, "HH:MM:SS") & " seconds"
    End Sub
    MemoryUsed: 524.476kB
    Time Taken: 00:00:05 seconds

    5 seconds? For a half MB pivot? What the heck, Excel...are you using your fingers to count?

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Ahh...it's specific to the pivot table i'm working on. Must have some bug in it somewhere, because I get the same result no matter what machine I try it with. However, if I extract all the data and make a new pivot, it takes no time at all.


    There you go.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •