Find 'unsupported features" and "unsupported links"

drsgizmo

New Member
Joined
Jun 28, 2019
Messages
10
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?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

drsgizmo

New Member
Joined
Jun 28, 2019
Messages
10
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,155
Office Version
  1. 365
Platform
  1. Windows
Did you follow the link at the top of that site entitled "Differences between using a workbook in the browser and in Excel"?
 

drsgizmo

New Member
Joined
Jun 28, 2019
Messages
10
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,155
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,084
Messages
5,545,860
Members
410,711
Latest member
Josh324
Top