Pivot Tables are Killers :(

Ragnar78

Board Regular
Joined
Feb 10, 2004
Messages
210
While i was launching a macro to refresh an set Page Fields in some pivot tables, i realised that one of the page fields is not actually setting all the value of the field it represents...
An since other pivot tables are all related to a main pivot, this problem has spread everywhere.

I would like to know if u have an answer concerning why a page field in a pivot table dosent show all the data that it should be showing.

I have checked all the settings...i am 100% sure that its not setting problem (i recreated another pivot table based on the same Data and it showed me the missing info in th epage field, so i did everything back and saved and the moment i reopened the file it was back as is :confused: )
Thank you for the help
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
uhmm..no
its just a page field...and i didn't put any condition on it...
It just dont seem to retreivea certain text value:
for example:
suppose the field name is: Crash and the type of data in it

Crash
Jog
Jog
FF
GR
GR
TK
TK
FF
GR

the page field should give those values: Jog, FF, GR, TK
but instead it gives me: Jog, GR, TK
 
Upvote 0
Hi:

Sorry, tried bu can not duplicate your error....just a thought...if the field is a calculated field, is your calculation switched to manual?


plettieri
 
Upvote 0
its just the page field u use to select (the filters that are usualy found on top of the pivot table
 
Upvote 0
What happens if you refresh the table manually?

Do you have any error traps in your code?
 
Upvote 0
the page field just dosent show all the available data...manualy or with the code (specially not with the code cause it tells me the calue dosent exist)

ActiveSheet.PivotTables("Main_Data_" & CStr(I)).PivotFields("TH_PROJECT").CurrentPage = _
nProject

the value nProject exist in the column TH_PROJECT of the selected data...but dose not exost in the Page Field TH_PROJECT that is suppose to contain all the diffrent variables in this field.
 
Upvote 0
What is the source of the PT? Is it correctly updated when you extend the source by adding data to it?
 
Upvote 0
The source is information on an other sheet, and i refresh the pivot before going through this procedure.

Im starting to think its an excel bug
:confused:
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,210
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top