Pivot Tables are Killers :(

[Ragnar78]

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

 

[tusharm]

That's not what I asked. Switch to the PT source sheet. What is the range of cells that contain data?

Now, add data to the source. What is the new range?

Get back to the PT worksheet and select any cell inside the PT. From the PT toolbar, select the wizard. In the Wizard, select the 'Back' button. What is the source? Is it the old source? Or the updated source?

 

[Ragnar78]

Yep it stayed the same when i change the source (from the same old source but with less rows)