2007 Excel Pivot Tables - turn off subtotals
 

Is they a way of turning off the "Subtotals" in columns and rows from the
start of creating the pivot table? In my Excel the option is greyed out under
Pivot Table OptionsTables & Filters .

Currently the only way I can find too turn them of is individually as I add
the column or row to the pivot table.

Any assistance is greatly appreciated.

2007 Excel Pivot Tables - turn off subtotals
 

Select a cell in the PivotTable
On the Ribbon, in the Design tab of the PivotTable Tools, click on
Subtotals.
Choose Do Not Show Subtotals

DingBat wrote:
Is they a way of turning off the "Subtotals" in columns and rows from the
start of creating the pivot table? In my Excel the option is greyed out under
Pivot Table OptionsTables & Filters .

Currently the only way I can find too turn them of is individually as I add
the column or row to the pivot table.

Any assistance is greatly appreciated.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

2007 Excel Pivot Tables - turn off subtotals
 

Hi Debra,

That's fixed it, thankyou.

Merry Christmas.

"Debra Dalgleish" wrote:

Select a cell in the PivotTable
On the Ribbon, in the Design tab of the PivotTable Tools, click on
Subtotals.
Choose Do Not Show Subtotals

DingBat wrote:
Is they a way of turning off the "Subtotals" in columns and rows from the
start of creating the pivot table? In my Excel the option is greyed out under
Pivot Table OptionsTables & Filters .

Currently the only way I can find too turn them of is individually as I add
the column or row to the pivot table.

Any assistance is greatly appreciated.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

2007 Excel Pivot Tables - turn off subtotals
 

You're welcome, and thanks for letting me know that it's fixed.
Merry Christmas!

DingBat wrote:
Hi Debra,

That's fixed it, thankyou.

Merry Christmas.

"Debra Dalgleish" wrote:


Select a cell in the PivotTable
On the Ribbon, in the Design tab of the PivotTable Tools, click on
Subtotals.
Choose Do Not Show Subtotals

DingBat wrote:

Is they a way of turning off the "Subtotals" in columns and rows from the
start of creating the pivot table? In my Excel the option is greyed out under
Pivot Table OptionsTables & Filters .

Currently the only way I can find too turn them of is individually as I add
the column or row to the pivot table.

Any assistance is greatly appreciated.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html