Hi,
I have several tables create over Web query using Power Query. And I have summary table created over those tables.
I want to refresh the tables so that my summary table shows the latest figures. When I update the tables Excel automatically selects last updated table. But I need Excel to show only summary table after update.
How can I set up Excel so that the tables (created over web query) are refreshed in background and it does not select those tables after refresh, but summary table?
Thanks,
Anar
I have several tables create over Web query using Power Query. And I have summary table created over those tables.
I want to refresh the tables so that my summary table shows the latest figures. When I update the tables Excel automatically selects last updated table. But I need Excel to show only summary table after update.
How can I set up Excel so that the tables (created over web query) are refreshed in background and it does not select those tables after refresh, but summary table?
Thanks,
Anar