Source data field description names changed

[tbobolz]

Excel 2010, PP V2

Hi all, I have a very large dashboard with vba, slicers, and many pages of different power pivots. We had an upgrade to our db and now the source header names have changed. Is there a way to update the power pivot data, so that it feeds to all pivot table and slicers?

I know I can left click on the PP window columns and update with the new name, however, when I go to update all the pivot data, I get errors that it fails to refresh, or name conflicts or it blows up the slcier connection.

Does anyone have a suggestion or know a better way?

Thanks for any help you can offer.

Terry

 

[GDRIII]

If you go into the Design tab of the PP Window can you make the adjustment with Table Properties?