PivotTable: how to add vertical lines in Data Item area

[blackpuppy]

After I drop a field in the Column Fields area, there are multiple
columns in the Data Item area (the main area for the numeric data).
How to add vertical lines in this area?

Thanks!

 

[Guest]

format the cells.

 

[Guest]

format the cells.

 

[blackpuppy]

I tried this out. Once I refresh the data using menu Data --> Refresh
Data, the formatting will be gone.

Sorry, I didn't state my scenario completely. I am using a .NET
WinForm app to control the Excel programmtically. The data will be
generated as XML and imported into Excel. So every time, I need to
refresh the data.

Any other ideas?

Thanks!