Forum Discussion
PivotTable data range change
Hello,
Please let me know how to change the data range of PivotTable which is created on MS team.
This file hosted on the MS team and I am unable to change the data range/ data selection parameter.
Best Regards,
Prasanna
10 Replies
https://fiveminutelessons.com/learn-microsoft-excel/how-update-or-add-new-data-existing-pivot-table-excel
Does it work on Excel for web?
SergeiBaklan a lot of functions don't work in excel for the web, so if it doesn't then there will only be one option left correct?
What do you mean under data selection parameter?
Within Teams
- select range -> Insert -> PivotTable
Right pane shall opens, select where to create PivotTable
Next exact location
Drag fields as necessary
Here it is
