Pivot Table Show detail to retained Pivot tables formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Microsoft,

When I have a pivot table summarising the Amount of "Spend" by each team I format the Spend field as a currency field in the data area. Now when I double click on it, it opens this detail in another worksheet but doesnt retain the formatting used in the pivot table.

Its my understanding that this is not possible.

Possible move forward in Excels development? I see pivot tables as one of the most useful area's in Excel.

Regards
 
In addition to posting your comment here, you can send suggestions to:

(e-mail address removed)

Put "Excel" in the subject line, so your suggestion will be forwarded to
the Excel product managers.
 

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

Pivot Table - Currency Format 1
Pivot Table 1
Pivot Table date format 1
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table - Changes 5
formatting pivot table report 5
Excel Pivot Tables 1
about pivot table 1

Back
Top