ExcelBanter - Pivot Table Total

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Total (https://www.excelbanter.com/excel-discussion-misc-queries/234673-pivot-table-total.html)

James

Pivot Table Total

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

--
James.

Luke M

Pivot Table Total

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!*

"James" wrote:

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

--
James.

James

Pivot Table Total

Obvious now! Many thanks Luke.

--
James.

"Luke M" wrote:

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!*

"James" wrote:

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

--
James.

All times are GMT +1. The time now is 12:37 AM.