refresh excel web queries only once

gtd526

Active Member
Joined
Jul 30, 2013
Messages
320
Office Version
  1. 2019
Platform
  1. Windows
Hello,
Im using Get Data from web using Queries in Excel. Is there a way to only refresh data once a day?

thank you
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Saurabhj

Active Member
Joined
Jun 6, 2020
Messages
413
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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

Active Member
Joined
Jul 30, 2013
Messages
320
Office Version
  1. 2019
Platform
  1. Windows
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

Active Member
Joined
Jun 6, 2020
Messages
413
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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

Active Member
Joined
Jul 30, 2013
Messages
320
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,994
Messages
5,622,053
Members
415,875
Latest member
Tarali

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top