2007 pivot table display data in row label

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have data in a row label that I want displayed as currency ALL the
time....BUT...when I refresh, the data changes back to the default. Any
suggestions?
Thanks
 
Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.
 
Also, right click on the PT>Table Options>uncheck Autoformat table

--
Regards
Roger Govier

trip_to_tokyo said:
Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.





__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot Chart Data Labels Disappear 1
Office 2007 Pivot Table Display format - Show row headings in each 1
Pivot Table (column/row) label cache reset 4
Conditional SUBTOTAL in XL210 Table 7
Pivot Table Refresh not working properly 1
07 Pivot Table side by side row labels 3
Pivot table layout that popluates the row label in each row? 3

Back
Top