How to Auto-Refresh Google Sheets Formulas (Updates Every 1-Minute)

Sometimes you may have a need for Google sheets to keep refreshing themselves after a certain time interval.

For example, if you’re tracking stock prices in Google Sheets or if you’re tracking currency conversions, then you may want Google Sheets to keep on updating every minute and showing you the latest values.

While you can force a recalculation by making a simple change in the Google sheets (such as editing a cell or deleting one), this is not an ideal solution.

In this Google sheets tutorial, I will show you how to auto-refresh formulas in Google Sheets so that it automatically updates every minute (on every hour if you need that setting)

So let’s get started!

How to Auto Refresh Google Sheets Every 1 Minute

Below I have a data set where I have the currency conversion from USD to various different currencies.

Currency conversion data that needs to autorefresh

I’ve got these values using the below Google finance formula:

=GOOGLEFINANCE("CURRENCY:"&"USD"&A2)

Here are the steps you need to take to make sure that this formlas refreshes every one minute in Google Sheets:

  1. Click the File optionClick the File tab
  2. In the drop-down, click on ‘Spreadsheet settings’Click on Spreadsheet Setting
  3. In the ‘Settings for this spreadsheet’ box, click on the ‘Calculation’ tabClick on Calculation tab
  4. Click on the Recalculation drop-downClick on On change and every minute
  5. Select ‘On change and every minute’Click on On change and every minute
  6. Click on ‘Save settings’Click on Save Settings

The above steps would change the setting of the spreadsheet so that it recalculates every minute as well as whenever you make any change in the worksheet.

In case you want to auto-update the Google Sheets document every hour (instead of every minute), then you can choose that setting from the dropdown in step 5.

When Not to Enable Auto Refresh

When you enable this setting, every minute Google Sheets is going to refresh the sheet and all the formulas would be re-calculated. why you may not see the change in every formula (as they may have the same value), volatile formulas such as NOW or RAND or RANDBETWEEN would recalculate every time.

If you have a small data set with less number of formulas, auto-refreshing your worksheet every one minute is not going to impact the performance.

But if you have a worksheet with a lot of formulas (especially long convoluted formulas using the kind of VLOOKUP, INDEX, or INDIRECT), you may see some lag in the performance.

So if you have a large spreadsheet with a lot of formulas, it is advisable to not enable this setting. you can try it out if you want, and if it doesn’t work out for you you can disable this setting.

And just to be on the safe side, take a backup before you try it out.

Note: I tried using this setting with some of the custom functions that I’ve created in the Google app script, and it did not work for me (you can give it a shot if you have custom functions that you want to refresh every one minute)

So this is how you can easily enable auto-update in Google Sheets so that it refreshes every one minute or every one hour.

I hope you found this tutorial useful.

Other Google Sheets tutorial you may also like