Hi all,
first of all I would like to praise the Atlassian team for developing the very useful add in for Excel. Now I can generate a lot go data in one single tab in Excel.
I know that the add in has an option to rerun my query every time I open the workbook, but since I have dozens of tabs for multiple queries, I need to manually put focus on each tab so the query is rerun and I have the latest data.
To make it easier, I tried to create a button in my summary page that basically would select each of those tabs using the following command
Sheets("tab_name").Select
and then come back to the summary page and I was hoping that would solve my problem to get each of those tab updated automatically because the focus was set to each tab.
But that is not happening. I would like to ask help on how I can trigger that all the queries in my spreadsheet get triggered one after the other with a single action.
regards
Diego Delgado
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.