vba: pagefield items don't refresh

marbel · Mar 13th, 2002, 12:17 PM

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

Mark W. · Mar 13th, 2002, 12:33 PM

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?

marbel · Mar 13th, 2002, 12:42 PM

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

Mark W. · Mar 13th, 2002, 12:45 PM

Quote:

...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 ]

marbel · Mar 13th, 2002, 01:38 PM

(bump)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 12:17 PM	#1
marbel New Member Join Date: Feb 2002 Posts: 5	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

Mar 13th, 2002, 12:33 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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?

Mar 13th, 2002, 12:42 PM	#3
marbel New Member Join Date: Feb 2002 Posts: 5	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

Mar 13th, 2002, 01:38 PM	#5
marbel New Member Join Date: Feb 2002 Posts: 5	(bump)