Hi all, new here and have a question that hope your community can help with.

I have an external API connection storing data in a single Excel tab. I then have another tab where I perform calculations using this data.

When I go to Data > Refresh All to refresh the API data (and my calculations), it always automatically switches tabs to the API data one.
I never really want to see or interact with that tab, as long as I know it's refreshing.

Any idea how to prevent Excel from switching tabs and stay on the current one?

Thanks a mil