Q2: You can use programming to lock some of the pivot table features,
as described he

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

IH wrote:
Q1: How do I use data from one excel file to populate the pivot table in
another file. I don't want users to be able to see the original file, i.e. I
want all pivot tables in an accessible excel file but the data in a different
excel file.

Q2: Is there a way to lock only certain pivot fields while allowing others
to be changed by my users?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html