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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

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,365
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,365
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,440
Messages
5,547,924
Members
410,818
Latest member
Beginner99
Top