Hi, I am using MS Office 2010 and I can not deal with the following problem:

Workbook_A - is shared and contains:
Sheet_A1 with the data;
Sheet_A2 with the data;

Workbook_B - is not shared and contains:
Sheet_B1 data, which union sheets A1 and A2 (select * from A1Table union select * from A2Table);
and sheets with pivot tables, supplied from a sheet B1;

Until Workbook_A is not shared everything works properly. On the other hand, when I share Workbook_A and execute refresh in Workbook_B, in PivotTables appear zeros (query in B1 is still working properly).

Unfortunately, the Workbook_B must be shared.

Do you have any suggestions?