Pivot Table Show detail to retained Pivot tables formatting

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
--
Adam
-----------
Windows 98 + Office Pro 97

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



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


Adam wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html