Frequently Asked Questions
Frequently Asked Questions
Limitations when accessing Office documents through Web browser
Posted by Peter Sandberg (M-Files) on 08 November 2019 02:19 PM

1     Overview

When accessing Office documents in Web browser, for example through the Co-Authoring feature, you might receive a warning that not all the document features are supported. In case the document is of type .xlsm and contains macros or other automation features, the warning can say the following:

This workbook cannot be edited because it contains following features:

  • Objects like for toolbar controls, toolbox controls, and ActiveX controls.
  • Scenario Manager.

 

2     Solution / Workaround

The Microsoft Office Online for Web browser looks a lot like the Office desktop app. However, there are some differences to be aware of. For example, not all file formats are supported, and some features may work differently than in the desktop app. The following MS article explains these differences.

Differences between using a workbook in the browser and in Excel

In case of .xlsm documents, you can open a Microsoft Excel workbook that contains macros but those will not be enabled. Through Web browser you can make changes to the worksheets and save the workbook, and the macros will still be there to work with when you open it in the Microsoft Excel desktop application.

 

 

(0 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako case