Imports a range of cells from a specified spreadsheet

​IMPORTRANGE is a powerful formula that allows you to bring in cells from other sheets.

On the free plan, IMPORTRANGE does not update when your sheet is closed. You have to open the importing sheet in your browser for the cells to update; it does not update continuously in the background.

With Glide Pro you benefit from the use of background refresh.