I read and re-read XL_Dennis' excellent articles on OWC - and started working w/the Pivot Control. To better understand the methods and properties I am using a persisted XML recordset with 12 fields. I have two questions:

1. Is it possible to set the backcolor for rowaxis, columnaxis?

2. I am trying to Exclude certain fields from the Pivot list. If I display 
oPIV.ActiveView.FieldSets.Item("Date_In_Stock").Fields(0).IsIncluded
I obtain -1. But if I try
oPIV.ActiveView.FieldSets.Item("Date_In_Stock").Fields(0).IsIncluded = False
I get an error - that "The fieldset 'Date_in_Stock' has no included fields. At least one must be included"

TIA

Stan