Forum Discussion
stever78
Aug 07, 2021Brass Contributor
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...
SergeiBaklan
Aug 07, 2021Diamond Contributor
12K of rows looks not very dramatic, but in any case I'd add you data source table to data model and build PivotTable based on data model table.
You may not use Power Pivot interface if you have only one source. Just use source loaded to data model to build reports.
- stever78Aug 07, 2021Brass ContributorHi, 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- SergeiBaklanAug 07, 2021Diamond Contributor
Yes, that will be new PivotTables with another data source. Do that on copy of your workbook.