Sorry, didn't read your note properly.

If you create the Pivot table directly in wkbk A, you should be able
to refresh it by hitting the "!" refresh button on the PivotTable
toolbar. If you are using VBA, try

ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh

Assuming you have selected the appropriate sheet, and the name of the
pivot table is PivotTable1.


HTH,
JP

On Nov 13, 2:16 pm, fbagirov
wrote:
I have a Pivot Table in the workbook A, and then a table in workbook B, that
is updated once a month. I then make a Pivot Table in wbk B, based on the
base table, then copy the Pivot Table from wbk B to wbk A, replacing the old
one in wbk A.
I need to be able to refresh PT in wbk A without replacing it, because links
to many other tables in wbk A get lost.

I tried to go to :

Data Pivot Table and Pivot Charts Report hit Back twice Select
External Data source, hit Next Get Data Excel Files * select the file
But I don't get the options to select the tables or the fields, moreover I
get an error something like "this is not an excel file" or "no tables were
found".

Please help! Thanks!