Power Pivot Table removes column upon refresh, will not allow them to be added back into table

[tbobolz]

Windows 7
Excel 2010

I have created a nice dashboard with multiple PP and slicer, inlcuduing some charts and creative desgin. Everthing is working fine; however, once I refresh the data, each pivot looses columns of data and once this happen, it will not even allow me to add the missing clomuns back into the pivot by dragging the field value to the "values" field of the pivot wizard. The entire workbook was created using the wizard. As I read around, others have had the same issue even when built with MDX, which I dont know much about.

Thanks for any help you can offer in resolving this issue. Hate to spend so many hour, to not be able to simply refresh the data each month.

Terry

 

[tbobolz]

I have found that both the original and power pivot field list still live in the borksheet. If you do not ensure that you are opening the field list from within the Power Pivot window tab, adding column back in will not work as you are most likely in the regular pivot table field list.

However, I still have not figured out why columns are being removed during refreshes.

 

[tbobolz]

Nice post there are many person searching about that now they will find enough resources by your post. Thanks for sharing.

Thanks, glad my efforts are helping others. Also found a nice link to a free 30 minute training video.


Learn Power Pivot for Excel | Chandoo.org - Learn Microsoft Excel Online