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 )
Thank you for the help
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 )
Thank you for the help