Workbook Link support coming to Excel for the web

RE: 

" I have a workbook that I am working in that has numerous sheets within in.   One of those sheets is a summary sheet of all the jobs (individual work sheets).   I want to link the job number on the summary page to the job worksheet so that I don't have to scroll through all the sheets to find that specific job sheet.   How do I do this?:

My workaround is to name the individual work sheet with "job number" so that they are visible without additional linking or XL4 macros to list sheets. Hope this helps.

I have a workbook that I am working in that has numerous sheets within in.   One of those sheets is a summary sheet of all the jobs (individual work sheets).   I want to link the job number on the summary page to the job worksheet so that I don't have to scroll through all the sheets to find that specific job sheet.   How do I do this?

Is it also possible to link two files saved in Sharepoint automatically with a macro (VAB)? I tried to sort out the appropriate path. But I could not succeed. When I use an example path I generated manually by copying the cells as explained above, it does not work.

Thanks for help!

Hi JCOLLINS0331, you mention "organization". So, this means you got the Excel linking functionality to work in your own personal organization and but can't get them to work in your current organization?  If so, you could consider asking your colleagues, in that organization, if they are having the same issue. This would point to , perhaps an Office 365 Admin setting that needs to be turned on. In Teams, restrictions can be applied to which SharePoint sites/Groups and content you get access to. So, opening an Excel workbook in a Teams tab does not necessarily give you access (via the linking) to other Excel workbooks. Though, that said, the error message, above, is perhaps an HTTP/Server caused error. That is, it is perhaps an intermittent error. Refreshing/quitting Teams can resolve that type of error.

Additional remediation, possible, is to recreate the links in the workbook or recreate a new worksheet in that workbook with the links or create a new workbook with the links in it.

You could, also, try reporting the issue in a support request to Microsoft. Give them that Error id. Use your own personal Microsoft work account to report the issue if you don't have access to the support reporting link in your organizational tenant.
Hope that helps.    

I use workbook links in my other ms teams / excel on the web spreadsheets but in this organization Im getting the following error.

I have tried everything i can think of. help?

Rodito_Buan 

You can try to use this example VBA to refresh your "external data connection" :

Sub UpdatingExternalCons()
' UpdatingExternalCons Macro
ActiveWorkbook.Connections("Query - SampleData").Refresh
End Sub

You should, then, insert that VBA into the Power Automate triggered solution as I have demoed here:  Run VBA on SharePoint Online for Excel files - YouTube

Checking if anyone figured out how to automatically enable the "external data connection has been disabled"?

What would be really useful, is if this feature could work with non-Excel formatted files!! For example csv. Csv files do open in Excel Online and we can see the data in individual cells, etc., yet when it comes to copy-pasting links it does not work.  

Hi Anders_Kjo , the way to use this is to either manually type the formula or copy the cells (range) from the source workbook and "past link".

As far as I am aware this feature has now been rolled out across the world, so it should be working for you. If not raise a support request with Microsoft. 

This function is really valuable, however I the selection paste special workbook link is not available unless I have something copied in the target workbook. And then that is what is copied in to the target cell - ie a copy within one workbook.

Is there anyone who has gotten this to work???