Find 'unsupported features" and "unsupported links"

[drsgizmo]

I have a large-ish .xlsx file that I keep live on sharepoint for multiple users to view/edit and it suddenly is saying that it has 'Unsupported Features' and external links. I've searched the whole workbook for external links and I have not found references to an external workbook in any cell. I also have no idea what the 'Unsupported Feature' is that is not allowing the file to be edited in the browser version of excel. Because of the particular use case of the file, this is a problem. Is there any way to find out where it is seeing links and what the unsupported features are?

 

[Fluff]

Have a look here
https://support.office.com/en-gb/ar...-the-web-7220105d-97ad-4c35-95c8-58d4bbfd14af

 

[drsgizmo]

I've seen that documentation and it doesn't help me. My file doesn't have XML maps and making everyone open the file in the application isn't a good solution in my scenario.

 

[Fluff]

Did you follow the link at the top of that site entitled "Differences between using a workbook in the browser and in Excel"?

 

[drsgizmo]

I did, I'm not finding anything that applies to my workbook. The only features that it lists as preventing a workbook from being opened in the browser is XML maps and Controls. I know that, for example, a watch window will prevent a workbook from being opened online. In my case, as described in the first page of documentation, the sheet opens in the browser but is read only.

 

[Fluff]

In that case I can only suggest you open the file in Xl app to try & find what is causing the problem. You can then remove the problem & it should then work for everyone.