Aug 25 2021 01:40 AM
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
Aug 25 2021 02:43 AM
What do you mean under data selection parameter?
Aug 25 2021 03:07 AM
Selecting the data range (number of column and row to be considered to run the pivot)
Aug 25 2021 03:44 AM
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
Aug 27 2021 12:27 PM
@Sergei Baklan 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?
Aug 27 2021 12:28 PM
Yes, just the question was exactly about Excel for web.
Aug 27 2021 12:32 PM
Aug 27 2021 12:34 PM
Then advise the user how to do it workable on web or inform that's not possible.
Aug 27 2021 12:37 PM
And is that what the user stated? or is it still a forthcoming response? How will the user know if it will work or not if the user did not try it first?