Excel 7.0 Dynamic Pivot Table FORMATTING
Posted on 1998-04-29
In Excel97 the pivot table has the ability to enable fields and format their contents and data anyway you want. If you click on a field it will select everything related with it. You can then select a format for that data. When you refresh the pivot table, the format STAYS.
However, in Excel 7.0, you CANNOT dynamically format. There isn't an enable function and when you apply formats to the data individually through the "normal" process, they disappear when the table is refreshed.
I would like to find out whatever information i can to get Excel 7.0 to dynamically format (ENABLE FEILDS or produce code that will recognize certain feild names and format the data accordingly, ie..If TransType (field name) = "revenue" (item in field) then format with $ and no decimals and have the format REMAIN when the table is refreshed.