Thanks for the reply. I didn't want it to refresh automatically throughout the day. After some research, it only updates once, I think.Hi, would you like to refresh queries automatically once a day?
Please check if below option helps:
- Right click the query.
- Select Properties.
- You can select "Refresh data when opening the file.
- You can also select "Refresh every" option and enter time in minutes (max: 999 minutes)
Thanks,
Saurabh
No, I'm good. Thank you.Yes, the option "Refresh data when opening the file" will refresh the query when you open the excel file.
"Refresh every" option will refresh the query after specified minutes.
Would you like to refresh query at a specific time ?