Although one can control the format, color and other characteristics of a
measure in the OLAP cube, Excel 2002 (and apparently 2003) don't recognize
this in a pivot table. Thus, the user has to reformat a cell each time a
measure is used. Furthermore, any "traffic lighting" that's done in the
cube (i.e., changing cell colors to indicate certain conditions) isn't
passed through to Excel.

Is there any work-around for this, or some add-in product that will help?

Thanks.

Jon