PivotTable data range change

Copper Contributor

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

@PrasannaSP0106 

What do you mean under data selection parameter?

@Sergei Baklan 

 

Selecting the data range (number of column and row to be considered to run the pivot)

@PrasannaSP0106 

Within Teams

- select range -> Insert -> PivotTable

image.png

Right pane shall opens, select where to create PivotTable

image.png

Next exact location

image.png

Drag fields as necessary

image.png

Here it is

image.png

@Yea_So 

Does it work on Excel for web?

@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?

@Yea_So 

Yes, just the question was exactly about Excel for web.

@Sergei Baklan 

 

Well obviously if the user tries it on the web and it doesn't work, then what?

@Yea_So 

Then advise the user how to do it workable on web or inform that's not possible.

@Sergei Baklan 

 

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?