How Can I Get Google Sheets To Auto Update A Reference To Another Sheet?

View our video tutorial:

Sometimes yous may accept a demand for Google sheets to keep refreshing themselves after a certain time interval.

For example, if yous're tracking stock prices in Google Sheets or if y'all're tracking currency conversions, and so you may want Google Sheets to go along on updating every minute and showing you the latest values.

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

In this Google sheets tutorial, I volition evidence you how to auto-refresh formulas in Google Sheets then that it automatically updates every minute (on every hr 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 take the currency conversion from USD to diverse different currencies.

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

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

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

Click the File option
In the drib-downwardly, click on 'Spreadsheet settings'
In the 'Settings for this spreadsheet' box, click on the 'Adding' tab
Click on the Recalculation drib-down
Select 'On alter and every minute'
Click on 'Save settings'

The above steps would change the setting of the spreadsheet so that it recalculates every minute likewise equally whenever you make whatsoever change in the worksheet.

In case yous want to automobile-update the Google Sheets document every hr (instead of every minute), and so yous can choose that setting from the dropdown in step five.

When Non to Enable Auto Refresh

When you lot enable this setting, every minute Google Sheets is going to refresh the sheet and all the formulas would exist re-calculated. why you may non come across the change in every formula (equally they may have the same value), volatile formulas such every bit Now or RAND or RANDBETWEEN would recalculate every time.

If you have a small data ready with less number of formulas, car-refreshing your worksheet every i minute is not going to impact the functioning.

Just if y'all have a worksheet with a lot of formulas (especially long convoluted formulas using the kind of VLOOKUP, Index, or INDIRECT), yous may meet some lag in the performance.

And so if you accept a big spreadsheet with a lot of formulas, it is advisable to non enable this setting. you tin can try it out if you desire, and if it doesn't work out for yous y'all can disable this setting.

And but to exist on the safe side, have 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 information technology did not work for me (you can give it a shot if you have custom functions that yous want to refresh every one infinitesimal)

So this is how you tin easily enable motorcar-update in Google Sheets and so that it refreshes every one minute or every 1 hour.

I hope you constitute this tutorial useful.

Other Google Sheets tutorial you may also like