vba: pagefield items don't refresh
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: vba: pagefield items don't refresh

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am trying to cycle through the pagefields of a pivot table, but the macro crashes if the items changed since the last update. For example, if the items were apple, orange, banana, and now they are apple, banana, cherry, it is still looking for pagefield "orange," and crashes. Why does the list not update, and how can I force it to re-evaluate the items? Thanks,
    mb

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not a VBA wizard, but I know a thing or two about PivotTables. Have you considered checking the "Show items with no data" PAGE field option?

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That is sort of the issue - I don't want to cycle through the items with no data... is there a way to limit the pagefields to items with data, programmatically? How would you ensure that it was re-evaluated for a pivottable refresh?
    Thanks for your input, you are definitely right about the items with no data causing my problem.
    mb

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ...is there a way to limit the pagefields to items with data, programmatically? How would you ensure that it was re-evaluated for a pivottable refresh?
    These are good questions that I'm unable to answer. But, "Hang in there". I'm sure someone else will respond to this thread.

    [ This Message was edited by: Mark W. on 2002-03-13 11:46 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    (bump)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com