Pivot tables empty after adding a calculated item

[tbobolz]

Hi All,

I have 2010 V2 power pivots. I am somewhat new to them. I have had failry good success with creating them, but when I add a new calculated field the pivot table blank out and not data is available once I make a filter change.

I also have slicers attached to the pivot tables

Am I missing something simple here?

Thanks
Terry

 

[Art15651]

In the Excel window, on the Data tab, click "Refresh All" and see if that does it.

 

[tbobolz]

It does not, but thanks for the thought!