Forum Discussion
Pivot table show details is adding 2 extra extra rows
Have tried to find related posts about this, but I'm getting a little frustrated, and it starts to be an inglorious search when half work is stall...
Company updated to Win11, Excel updated to "Microsoft® Excel® for Microsoft 365 MSO (Version 2502 Build 16.0.18526.20168) 32-bit"
And now, when I double click on a Pivot value to "show details" in the new sheet are added 2 new rows on the top:
This is adds no value to the show details sheet and it is disruptive in the worst way possible.
So my question is simple, how do I turn off this "new feature", and if I can't turn it off, when is going to be reverted?
If you're inclined to use cloud services, you can automate copying values and formatting using Power Automate by creating a flow that watches for changes in a cell and then pulls over values and formats as specified.
To my knowledge there is no such option.
As for the suggestion to revert it's better to do it on Microsoft Feedback portal for Excel Excel · Community and/or upvote/comment this suggestion Pivot details · Community, Microsoft keeps it in status Open.
More feedbacks in above resource more chances it will be done one day.
