refresh excel web queries only once

[gtd526]

Hello,
Im using Get Data from web using Queries in Excel. Is there a way to only refresh data once a day?

thank you

 

[Saurabhj]

Hi, would you like to refresh queries automatically once a day?

Please check if below option helps:

1. Right click the query.
2. Select Properties.
3. You can select "Refresh data when opening the file.
4. You can also select "Refresh every" option and enter time in minutes (max: 999 minutes)

Thanks,
Saurabh

 

[gtd526]

Hi, would you like to refresh queries automatically once a day?

Please check if below option helps:

1. Right click the query.
2. Select Properties.
3. You can select "Refresh data when opening the file.
4. You can also select "Refresh every" option and enter time in minutes (max: 999 minutes)

Thanks,
Saurabh

Thanks for the reply. I didn't want it to refresh automatically throughout the day. After some research, it only updates once, I think.

 

[Saurabhj]

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 ?

 

[gtd526]

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 ?

No, I'm good. Thank you.