Import a workbook/worksheet and use the data to update pivot tables

[GrahamDickinson]

Hi, I have a business applicaiton which outputs either a formatted pdf report or the raw data for the report into Excel an workbook. If the users output to Excel they then manipulate the data via pivot tables before saving/printing the finished work. I have found that most of the users are doing the same formatting work repeatedly. I have now created a macro enabled workbook called PivotViews which contains several pivot views of the report each as a worksheet with a unique name say Pivot1 Pivot2 etc. The source data is in a worksheet called InputData. What I want to be able to do is using VB in my PivotViews workbook, ask the user to point to the Excel output they have just created and import it into the Pivotviews workbook, overwriting the InputData worksheet. I then need this new data to be refreshed in the Pivot1 Pivot2 etc sheets. Can anyone help please.