Importrange function in Excel online

Question

Importrange function in Excel online

Anonymous

Dears,

This question was asked 4 years ago, is there any update?

In online google sheets you can use function of importrange which shows the whole data in another sheet in another sheet, I want to know that is there any function same as importrange of google sheet to use it in online excel ?

Your Sincerely,

Michael

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Hi MIcktamis,

Thank you for reaching out. My name is Leo, a user just like you. I'd be happy to help you with your concern.

Microsoft has already announced an option similar to importrange, which is the workbook link. It was first released in Excel desktop applications, and now it is available in Excel online as well. To use the workbook link, follow the steps below:

Open your Microsoft Excel online.
Open two workbooks in Excel for the web (they should be stored in either OneDrive or SharePoint)
In the source workbook, copy the range.
In the destination workbook, ‘Paste Links’ via the right-click menu or via ‘Paste Special’ on the ‘Home’ tab.

Alternatively, you may reference the workbook explicitly using the following reference pattern:

='https://domain/folder/[workbookName.xlsx]sheetName'! CellOrRangeAddress

If you ignore or dismiss the bar, we will not be able to update the links. This will mean the values will remain as previously displayed. If you click the ‘Enable Content’ button, Excel for the Web will retrieve the values from all the linked workbooks.

To help you manage these links, Microsoft has added a new ‘Workbook Links’ task pane. This task pane may be accessed by pressing the ‘Workbook Links’ button on the Data tab.

For more detailed steps with corresponding images, you can refer to the link provided below:

https://www.sumproduct.com/news/article/excel-for-the-web-workbook-link-support#:~:text=This%20has%20been%20missing%20from,in%20either%20OneDrive%20or%20SharePoint)

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

I hope I provided a helpful information regarding your concern! Let me know if you have any further questions.

Best Regards,

Leo