Pivot Table Total

J

James

Hello

Does anyone know how to turn off "Totals" in Excel 2003. I can't find it and
it's driving me crazy!!

many thanks
 
L

Luke M

Right-click on the Table, go to "Table Options". Uncheck "Grand total for
rows" and "Grand total for columns". You may also need to change the
inidvidual field settings and remove subtotals, if you have those as well.
 
J

James

Obvious now! Many thanks Luke.


--
James.


Luke M said:
Right-click on the Table, go to "Table Options". Uncheck "Grand total for
rows" and "Grand total for columns". You may also need to change the
inidvidual field settings and remove subtotals, if you have those as well.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
Top