Forum Discussion

PrasannaSP0106's avatar
PrasannaSP0106
Copper Contributor
Aug 25, 2021

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 paramet...
excel
Excel for web
Formulas and Functions
PrasannaSP0106's avatar
PrasannaSP0106
Copper Contributor
Aug 25, 2021

SergeiBaklan 

 

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 25, 2021

    PrasannaSP0106 

    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

Resources