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
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

Could the field in question be text vs a number required?

plettieri
 

Ragnar78

Board Regular
Joined
Feb 10, 2004
Messages
210
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
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS

ADVERTISEMENT

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
 

Ragnar78

Board Regular
Joined
Feb 10, 2004
Messages
210
its just the page field u use to select (the filters that are usualy found on top of the pivot table
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028

ADVERTISEMENT

What happens if you refresh the table manually?

Do you have any error traps in your code?
 

Ragnar78

Board Regular
Joined
Feb 10, 2004
Messages
210
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.
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
What is the source of the PT? Is it correctly updated when you extend the source by adding data to it?
 

Ragnar78

Board Regular
Joined
Feb 10, 2004
Messages
210
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:
 

Watch MrExcel Video

Forum statistics

Threads
1,123,143
Messages
5,599,975
Members
414,354
Latest member
Flaxarn

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
Top