Hi all,
Have been trying to get an Excel document working within SharePoint online. The document was created in Excel offline, and with very basic macros (drop down menus with auto-fill functionality) and it works flawlessly within Excel. It is a simple, lightweight document after all.
Once uploaded to SharePoint however, there are compatibility warnings and the drop-down macros do not function:
Unsupported FeaturesThere are some features in your workbook that we can't show in the browser.
• Objects such as form toolbar controls, toolbox controls and ActiveX controls
But you can see all of the content in this workbook by opening the file in Excel.
I have tried every browser - I.E., Edge, Chrome... you name it and the issue persists. I have read that this may be a bug that has spanned several years with no fix other than a 3rd party extension for Chrome. This is too much of a security risk for the business, so looking for a workaround.
Many thanks.