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!