Worf
Well-known Member
- Joined
- Oct 30, 2011
- Messages
- 4,261
Worf submitted a new Excel article:
Office scripts, VBA and a text pivot table - This article shows how to place text in the values area of a pivot table
Read more about this Excel article...
Office scripts, VBA and a text pivot table - This article shows how to place text in the values area of a pivot table
One way to display text in the values area of a pivot table is to use conditional formatting with a custom number format. Unfortunately, Excel scripts currently cannot apply this kind of feature to pivot tables, only to ordinary cells.
On the other hand, good old VBA can do it. So, this is a hybrid project using these two different languages. Here are the main points:
- It is done with a single click because the VBA code is event driven and will automatically run when the TypeScript...
Read more about this Excel article...