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
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