I have a bit field in my SQL Server data table called 'inPub' with 1/0 True/False values.
When I surface the data in an Excel pivot table I get a layout like this
How do nI change those TRUE/FALSE display values into something more meaningful and insightful such as InPub/NotInPub
you could choose to overwrite the value's in the pivottable just by typing over them.
Nicer would be to put a view on you table in SQL server used for reporting (second layour on base data)