Refreshing Queries in Workbook
Would like to have the solution from the forum:
Scenario: Suppose there is a workbook with multiple queries.
Requirement: When I refresh the workbook, all the variable values should get reflected in the embedded queries and each query should show updated data.
Question: Could you tell me the settings for this?
Thanks in advance,
In the workbook properties there is a option to refresh the variable up on opening the workbook.
Hope this helps.