Share via

Need help minimizing sheets that open when values on pivot table are double clicked

Anonymous
2022-02-18T02:26:41+00:00

Hello!

HELP! Need help minimizing sheets that open when values on pivot table are double clicked. Everytime the values/counts are double clicked all these sheets keep opening. Have not been able to find a video or help minimizing these sheets from opening.

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

Answer accepted by question author

Anonymous
2022-02-18T07:48:17+00:00

Hi,

Please check whether the following solution is helpful:

Step 1. Please click on any cell in the PivotTable.

Step 2. Please do a right-click > please click on PivotTable Options.

PivotTable Options box will open.

Step 3. In the PivotTable Options box > please click on Data tab > please uncheck the option Enable show details.

Result: now when You double-click, another worksheet will not get added.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-21T02:02:11+00:00

    Hello, Shantale

    We didn't receive your reply. May I know if you referred to reply provided by Mark_My_Words? Please let us know if you need further assistance.

    Best Regards,

    Igor

    Was this answer helpful?

    0 comments