Forum Discussion
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,...
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.
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.
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
