Forum Discussion
to POWER PIVOT or not ???
Hi I Would very much appreciate your views on my what my next step is to avoid my SLOW standard pivot tables. i have ONE large source worksheet with 12000 rows and 5 columns of data. i have 6 pivo...
Hi, thanks for replies, appreciated.
i have created the data model. My previous pivot tables still have the same source data. even though i have added that source data to a data model.
do i need to create NEW pivot tables using the Pivot tables creation button on the power pivot interface ( when you click manage ). i.e is there no way i can copy my existing standard PTables
thanks, steve
i have created the data model. My previous pivot tables still have the same source data. even though i have added that source data to a data model.
do i need to create NEW pivot tables using the Pivot tables creation button on the power pivot interface ( when you click manage ). i.e is there no way i can copy my existing standard PTables
thanks, steve
Yes, that will be new PivotTables with another data source. Do that on copy of your workbook.