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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 27, 2021

Yea_So 

Does it work on Excel for web?

Yea_So's avatar
Yea_So
Bronze Contributor
Aug 27, 2021

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?

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

    Yea_So 

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

    • Yea_So's avatar
      Yea_So
      Bronze Contributor
      Aug 27, 2021

      SergeiBaklan 

       

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

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

        Yea_So 

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

Resources