Has anyone been able to get the display formats in AS to pull into an Excel
Pivot table automatically? For example, if I set the display format of a
measure in AS as $#,# it gets pulled into the Excel Pivot table with no
format. Is there a way to get this to work?

Thanks!
Melinda

You can set some properties to do this on an Office XP (or later) Pivot
Table Component - I'm not aware of a way to do this within Excel itself:

http://support.microsoft.com/default...b;en-us;318122
PivotTable Component
Article ID : 318122
Last Review : June 30, 2004
Revision : 2.0
This article was previously published under Q318122

On this page
SUMMARY
MORE INFORMATION
REFERENCES

SUMMARY
The Microsoft Office XP PivotTable component supports two undocumented
properties: UseProviderFormatting and DisplayCellColor. These properties
allow you to use server formatting for cells and totals in a PivotTable
view.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Working by Visual Studio .Net, I see that some data information from olap
cube are gotten only value nad nothing other. It is up to the program of
reading format this values.



"Deepak Puri" wrote: