If you have updated the data of a Pivot Table and it is not being pulled through there are a number of possible reasons. Here we go through them in order of likelihood.
How to use the new Navigation button in Excel to easily see and jump between sheets and elements (tables, charts, PivotTables, and images) in big Excel spreadsheets.
When you use the average function in Excel, it is important to decide what you want to do with zeros. Should they be considered in the average i.e. they are part of the calculation or should they be ignored i.e. the item is there but you want Excel to determine an average without taking that item into account.