When you need to import a range from an Excel workbook that is not open, use the formula bar method.

This method works well if your source and destination spreadsheets are open. Now if you change some values of the imported range in the source file, the values in the destination spreadsheet will be updated as well. You can expand the imported range by simply dragging the cross as follows: Go to your destination spreadsheet, select either one cell to import the entire range or a range of cells to only populate the selected cells. Select a range of cells in the source spreadsheet and copy them: you can use either Ctrl+C or right click => Copy. Open both a source and a destination Excel spreadsheet. How to use IMPORTRANGE equivalent for Excel desktop

The implementation of an Excel IMPORTRANGE equiv depends on the Excel app you use (365/Online or desktop app). In Excel desktop, it has no explicit name, but is implemented via the Paste Link option. In Excel Online, the IMPORTRANGE functionality is called WorkBook links. What is the Excel version of IMPORTRANGE? This can be done either by copying and pasting a data range or by using a formula bar. However, there is no IMPORTRANGE function.Īt the same time, Excel provides a similar to IMPORTRANGE functionality for linking a data range from a separate spreadsheet. There are many functions in Excel, such as VLOOKUP Excel or SUMIF Excel.

IMPORTRANGE, Workbook Links, or Coupler.io Is there IMPORTRANGE in Excel?

Excel online 2021