Pivottable Cubefield vs PivotField

Hi guys.

Ok, so here is a weird one that I'm experiencing today.

I have a workbook with a pivottable and have written some macro code which would execute successfully.
I previously referred to pivotfield, but today the file is looking for a reference to cubefield.

Is there some kind of setting in the options that I may have inadvertently turned on/off which now refers to pivotfields as cubefields?

I can't upload the file here, but here is some info:
I download the file from a central server, and click a refresh button (which I think refreshes data connections).
Prevoiusly, my code referred to the pivottable fields and it worked fine.
Today, the code doesn't want to execute correctly so I then went and used the macro recorder which gave me this code:

Please Login or Register  to view this content.

I see that it refers to cubefields.
So I'm going through the code in VBA to replace references to cubefields instead of pivotfields.

Any thoughts on this?
What is the difference between a cubefield and pivotfield?
Why does it now refer to cubefields?
Why doesn't pivotfield work? Do you have to always use cubefiled OR pivotfield?


Thanks in advance.

Yes, the cube data gets updated each month. I don't actually know anything about cubes but this is a report which gets updated at the end of each month.
I can see 5 data connections when I click on Data -> Connections.

Initially, I had an "on error resume next" line in the code, so it would execute to the end but the outputs looked all wrong (pivotfields not in the arrangement that the code was supposed to execute on).

So I "texted it out" and then I got the error - "Run time 1004: Item name cannot be found..."

Then when clicking the debug button, it highlights a line which refers to pivotfield.
When I change this code to refer to cubefield then the code runs ok.

Had to go back and change the code in a few places, and learnt that the syntax for cubefields can be quite different to the syntax for pivotfields.

You can't do subtotals on cubefields, you have to reference pivotfield eg.

Please Login or Register  to view this content.

When doing the subtotal, you have to state the field name twice as above.
When bringing int he field to a pivot, you have to state it once:

Please Login or Register  to view this content.

When adding a data field, it looks like this

Please Login or Register  to view this content.

Turned out to be quite a pain in the a$$.

I think there is some kind of background setting that I turned on by mistake,
The reason I say this is because I took a report from 2 months ago (where my old code worked fine), and that old file is also "looking" for Cubefield references.

Originally Posted by Izandol

I think perhaps the name or caption of the field in the field list is different from the text in your code?

The caption was exactly the same And it wasn't a calculated field either.