I was hoping to update the PivotTable through VBA. Creating another
PivotTable through the wizard would require the user to know and understand
PivotTables.

"Patrick Molloy" wrote:

you can use another excel workbook as if it were another data source. You can
create a new pivot table using the Data/Pivot Table menu an dfollow the wizard

"ASteele" wrote:

I am wondering if it is possible to update a PivotTable, based on data set in
another worsheet? I have to create a summary report with variable data set
in my "Report" worksheet. I can manually update the PivotTable with the
variable data when in the PivotTable worksheet. However, I would like to
keep the PivotTable data manipulation out of the hands of the users. In
other words, I would prefer them to input pertainant information through an
input dialog and print a report based on criteria set in the "Report"
worksheet.