Pivot table cell is blank inappropriately

[ghart191]

Hello All,

I have a pivot table linked to a data table via a named range. The data table and named range get updated by a macro. After the macro is run, I've noticed that some of the cells in one of the label columns are blank even though they should have data. If I double click the cell which would normally drill down to the supporting data, it instead causes the data to show up.

I'm using Excel 2010 on Windows 7. Any help is appreciated.

Thank you,
Gabriel

 

[Derek Brown]

Hello and welcome to The Board.
If the source data changes, the pivot table needs to be refreshed (right mouse-click a cell in the pivot table and select 'Refresh'). The pivotcache can also be refreshed from VBA.

I'm using Excel 2010 on Windows 7

Be aware of this if you are using add-ins in particular:
http://office.microsoft.com/en-us/w...-version-of-microsoft-office-HA010369476.aspx