Hi, i hope anyone has an idea for that:
I have a pivot table bound to a data range in the same excel sheet. Now I want to bind the table to an external source (in this case powerpivot). If i choose "Chage Data Source" from pivottable ribbon, I can only choose another range, but external connection is greyed out.
Is there a way to do this, otherwise I'd have a lot of work recreating many pivottables.
Btw, another question, when I add fields to a new pivottable, is there a way to prevent the pivot from refreshing after each field, or to add multiple fields at once? With a lot of data/fields behind this is quite uncomfortable and slow.
Any help will be greatly appreciated, thanks, Gert
Bookmarks