Formatting when doubleclicking in pivot tables

  • Thread starter Thread starter H. Rye
  • Start date Start date
H

H. Rye

When I double-click in a pivot table, a new sheet is created, showing the
details behind the cell in the pivot table. However, the new sheet is
formattet automaticly, which causes a lot of problems. How can I controll
this auto formatting?
 
I don't believe you can. You would need to write event related code to
reformat the sheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Playing back a Pivot Table macros 2
Pivot Table Question 2
create a pivot table and chart from a named range 1
Pivot table code question 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Automatically Update a Pivot Table Field Used as Column / Row 1
Pivot Table Macro 2

Back
Top