software

I have created a Pivot Table and graph. The graphs will be available for use
by my coleges to interigate data. The table/graph consists 4 Pivot Table
Fields, can I fix some of the fields so that cant be removed however my
collegue will need to be able to add further fields
--
pk

You can use programming to prevent fields from being dragged to a
different location, or off the pivot table. There's sample code he

www.contextures.com/xlPivot12.html

PK wrote:
gt; I have created a Pivot Table and graph. The graphs will be available for use
gt; by my coleges to interigate data. The table/graph consists 4 Pivot Table
gt; Fields, can I fix some of the fields so that cant be removed however my
gt; collegue will need to be able to add further fields--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlDebra, many thanks for your help, one thing I forgot to mention is that the
pivot table buttons are on a chart sheet, and the code suggested won't work
it says Run Time Error '438' Object dosn't support this property or method.
Can you suggest a soloution? Many thanks

quot;Debra Dalgleishquot; wrote:

gt; You can use programming to prevent fields from being dragged to a
gt; different location, or off the pivot table. There's sample code he
gt;
gt; www.contextures.com/xlPivot12.html
gt;
gt; PK wrote:
gt; gt; I have created a Pivot Table and graph. The graphs will be available for use
gt; gt; by my coleges to interigate data. The table/graph consists 4 Pivot Table
gt; gt; Fields, can I fix some of the fields so that cant be removed however my
gt; gt; collegue will need to be able to add further fields
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

Instead of:

With ActiveSheet.PivotTables(1)

use:

With ActiveChart.PivotLayout.PivotTable

This will affect the pivot table on which the pivot chart is based.Graham F wrote:
gt; Debra, many thanks for your help, one thing I forgot to mention is that the
gt; pivot table buttons are on a chart sheet, and the code suggested won't work
gt; it says Run Time Error '438' Object dosn't support this property or method.
gt; Can you suggest a soloution? Many thanks
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;
gt;gt;You can use programming to prevent fields from being dragged to a
gt;gt;different location, or off the pivot table. There's sample code he
gt;gt;
gt;gt; www.contextures.com/xlPivot12.html
gt;gt;
gt;gt;PK wrote:
gt;gt;
gt;gt;gt;I have created a Pivot Table and graph. The graphs will be available for use
gt;gt;gt;by my coleges to interigate data. The table/graph consists 4 Pivot Table
gt;gt;gt;Fields, can I fix some of the fields so that cant be removed however my
gt;gt;gt;collegue will need to be able to add further fields
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Excel FAQ, Tips amp; Book List
gt;gt;www.contextures.com/tiptech.html
gt;gt;
gt;gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlDebra, Brilliant, works a treat, with the addition of a routine to ensure
macros are enabled (Which I have) and some error trapping(which I have done)
I can release my pivot charts into the world!! once again many thanks

quot;Debra Dalgleishquot; wrote:

gt; Instead of:
gt;
gt; With ActiveSheet.PivotTables(1)
gt;
gt; use:
gt;
gt; With ActiveChart.PivotLayout.PivotTable
gt;
gt; This will affect the pivot table on which the pivot chart is based.
gt;
gt;
gt; Graham F wrote:
gt; gt; Debra, many thanks for your help, one thing I forgot to mention is that the
gt; gt; pivot table buttons are on a chart sheet, and the code suggested won't work
gt; gt; it says Run Time Error '438' Object dosn't support this property or method.
gt; gt; Can you suggest a soloution? Many thanks
gt; gt;
gt; gt; quot;Debra Dalgleishquot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;You can use programming to prevent fields from being dragged to a
gt; gt;gt;different location, or off the pivot table. There's sample code he
gt; gt;gt;
gt; gt;gt; www.contextures.com/xlPivot12.html
gt; gt;gt;
gt; gt;gt;PK wrote:
gt; gt;gt;
gt; gt;gt;gt;I have created a Pivot Table and graph. The graphs will be available for use
gt; gt;gt;gt;by my coleges to interigate data. The table/graph consists 4 Pivot Table
gt; gt;gt;gt;Fields, can I fix some of the fields so that cant be removed however my
gt; gt;gt;gt;collegue will need to be able to add further fields
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;Debra Dalgleish
gt; gt;gt;Excel FAQ, Tips amp; Book List
gt; gt;gt;www.contextures.com/tiptech.html
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;