Pivot Table questions

D

Dave

I have several questions about a pivot table I am constructing.

1. Is there a way to have a column reference a cell with data instead of
using the drop downs? example - first column in table is part number,
instead of using the drop down to search for parts is it possible to
reference cell A1 where a part number would be typed by the user.

2. Is there a way to lock a table so the columns can not be added or removed?

3. I do not have anything in the data items or column fields sections, is
there a way to remove these sections?

Thanks
 
D

Debra Dalgleish

In question 3, you say that your pivot table doesn't have data or column
fields, but your first two questions refer to data and columns.

Maybe you could describe what's in the pivot table, and what you're
trying to achieve, so someone could offer specific advice.

However, there's information here on enabling or disabling pivot table
features, by using programming:

http://www.contextures.com/xlPivot12.html
 
Top