Sign up for Office 365
Learn more about Office 365
We have Excel workbooks that contain links to other workbooks. We also have worksheets within a workbook that are linked to other worksheets in the same workbook.
Is there a way to upload these documents to Sharepoint so that the links still work?
As far as I know links and inserted object unable to work on web (Excel online).
However, you can select “Edit in Microsoft Excel” to open and edit the Excel workbooks.
1 out of 2 people found this post helpful.
I did open it in Excel, but the links still didn't work. The yellow bar says: "Links Disabled. Links to external workbooks are not supported and have been disabled." The next yellow bar says: "Unsupported Features. This workbook may not display as intended. Details..." Do I need to activate some kind of external links feature in Sharepoint, Office 365, Excel?
0 out of 1 people found this post helpful.
I understand that it's not supported in the web app, but I am trying to open it from Sharepoint in Excel on my computer (not the web app).
Sorry, didn't see your 2nd post, I only saw:
"Is there a way to upload these documents to Sharepoint so that the links still work?"
Same answer applies though probably because when you open in Excel from SP you're only querying the stored doc, not downloading it locally.
If you open the Excel files with Microsoft Excel on your computer, please take notice of below:
1. If you insert the workbook as an Object (not a link), it’s available.
2. If you insert the workbook as an Object with a link which is link to local files (Example: =Excel.Sheet.12|'C:\Users\xxxxx\Desktop\test03.xlsx'!'''') it’s available.
3. If you insert the workbook as an Object with a link which is link to Sharepoint online library (Example: =Excel.Sheet.12|'https://xxxxx.sharepoint.com/MyDoc/test03.xlsx'!'''') it’s unavailable.
How are the things going?
In addition, do you need further assistance on the issue?