Forum Discussion

DSM_user's avatar
DSM_user
Copper Contributor
Sep 26, 2023

GET Pivot DATA disabled but not working

I am working with a file in TEAMS; however, I am opening the file with the excel app. I need to do some simple calculations outside a Pivot Table. I have already disabled the GET Pivot DATA option,...
excel
DSM_user's avatar
DSM_user
Copper Contributor
Sep 26, 2023

LeonPavesic 

 

Thanks for the reply. sorry maybe I wasnt clear.,

 

Solution 1) and 2) does not work. The file is already in xlsx format and the workbook is not based on data model.

I am trying to effectively disable the function. 

In image one you can see that the formula is not dragging, only the values.

But if you see in the formula, is not using the get pivot, the formula is correct but the values are not showing correctly (normally you should see the "get pivot" if the function is enabled.

I already disabled the function both from Pivot Table Analyze -> Pivot Table -> Options

And from File -> Options -> Formulas

But excel keeps behaving as if it were enabled.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 26, 2023

DSM_user 

Excel for web (aka in Teams) works with references even if GetPivotData function is disabled in desktop app for PivotTable references.

The only I may reproduce your case if to keep Calculation Mode manual in Teams interface.

  • DSM_user's avatar
    DSM_user
    Copper Contributor
    Sep 27, 2023

    SergeiBaklan 

     

    Thanks, I solved it. 

    I noticed this small icon in the bottom left that says "Calculate" and if I click it, it shows the right information.

    I do suspect this comes from TEAMS and not .xls. How do you keep calculation mode manual in teams interface? I know how to do it in desktop app

     

Resources