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