Share via

How to turn off the new "feature" in excel pivot table where 2 additional rows are added at the top of a pivot table after drill down.

Anonymous
2025-01-02T20:03:32+00:00

This is creating issues with my worksheets - where is the option to disable? I do not want the extra rows starting with "Details for xxxxx"

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-01T09:53:14+00:00

    I have reported it to relevant team. Hope Microsoft will add an option to disable it in the next version.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-31T14:53:55+00:00

    This is the version:

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-01-31T11:44:30+00:00

    This new ''feature'' is very annoying, it serves no purpose and it ruined all my macros, I can't run my daily reports. Colleagues with older version of Excel must do these tasks for me.

    Please, add the option to remove it.

    Thanks

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-01-03T03:36:24+00:00

    This new design in Excel. You may send feedback to Microsoft to add an option to disable it. I will also report your request to relevant team.

    Your Feedback makes Office Better 

    Could you share the Excel version you are using? Is it possible to rollback to previous Excel version as temporary workaround?

    File>Account>Product information

    Was this answer helpful?

    0 comments