Pivot Table formatting

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a pivot table where I can left click on the fields such as Customer
or Sum of Quantity and it highlights all of the cells in that fields row or
column in a reverse video and then I can format that data and everything is
great. I am working with someone over the phone that when they click on the
field, it does not highlight the associated data cells and therefore they
can not format the data and save those formats for when they change the
pivot table.

Any ideas why this might be? We are both using Excel 97.

Thanks,
Steve
 
To turn on the Enable Selection feature:

From the Pivot toolbar, choose PivotTable>Select
Click on Enable Selection
 
Back
Top