Re: Pivot tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Debra, many thanks for your help, one thing I forgot to mention is that the
pivot table buttons are on a chart ***, 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

"Debra Dalgleish" wrote:

> You can use programming to prevent fields from being dragged to a
> different location, or off the pivot table. There's sample code here:
>
> http://www.contextures.com/xlPivot12.html
>
> PK wrote:
> > 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
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
.

Quantcast