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?

Thank you,
IH