• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel selects updated tables instead of summary table

Anar

Member
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
 
Back
Top