AddItem directly to a Pivot Table's cache?

[Glory]

Is it necessary to update the source range, or is it possible to use VBA to add and remove items to and from a pivot table's cache?

 

[Glory]

Bump.

 

[MrKowz]

You need to update the source range. However, one way to accomplish this without having to MANUALLY update the source range would be to insert a column that lies inside of the range.

For example, if your source range is A1:M100, you can insert a column anywhere in that, and the source range will automatically change to A1:N100.

 

[Glory]

It's a sure thing then? That seems so counter-intuitive. I'm yearning for some obscure method that will let me jailbreak the pivot table's cache.

It might seem like an arbitrary difference, but the point is that all I need to be able to do is to select an entry from a pivot field when that entry happens not to appear in the pivot field. That requires the number to be present in the pivot field (and if I don't want to add it every time the file opens, the pivot table cache), but not the source range.

Adding information to the source that isn't already there will seem really unappealing to the people requesting this tool. But I guess what they don't know won't hurt them.

I've been boning up on class modules to the best of my ability. I got one working tonight that gave me a checkbox. I've just bumped the post on that one for the... fourth time I think?

I'm real close now though. I've got everything working except the thing that will check to make sure projects are present (since I can't edit the pivot cache directly), the thing that will select the numbers from the pivot field, and the runtime controls that are coded.

Real close, and it feels real good.