Jun 11, 2019 With programs like Word and Excel for Mac, it’s no wonder that the MS Office suite is a must-download on any computer. Microsoft Office for Mac 2019 includes the most modern versions of Word, Excel, Powerpoint, Outlook, and OneNote. These apps are all. If you aren't comfortable using unsupported software on your Mac and don't like the idea of upgrading to Office 2016, there are other options.
![]()
Hello Everyone, When I open some workbooks my company uses for our finances I get the following error message since upgrading to the latest version of Office. This workbook contains content that isn't supported in this version of Excel.0017 To view theunsupported content in the file, you can open the workbook as read-only. However, if you change and then save the workbook, unsupported content will not be saved. Then it offers for me to open as 'Read-Only' I'm running Microsoft Excel for Mac version 15.12.3(150724) Obviously this could be a big issue for me. Anyone else had this happen and know of a fix?
-->
Microsoft Excel is feature-rich. With every release, the functionality gap between Excel and Excel Services gets narrower, and the number of unsupported features is reduced. But is not possible to support every Excel feature in the second version of Excel Services, in Microsoft SharePoint Server 2010.When deciding which feature to support, priorities are given to features that are needed in key Excel Services scenarios, and to ensuring that Excel Services is a server-grade service that meets customers' expectations for reliability, scalability, and security.
Note
This topic assumes that you are familiar with what is supported and unsupported in Microsoft Office SharePoint Server 2007. You can find more information about the unsupported features in Office SharePoint Server 2007 in Unsupported Features in Excel Services.
Support for New Excel Features![]()
Most of the new features in Microsoft Excel 2010 work in some way in Excel Services. Some features display as they do in Excel. Others can be displayed and are also interactive.
Following are new features that can be viewed:
Following are new features that can be viewed and interacted with:
The new functions in Excel are also supported. Embedded images, a long-time feature of Excel, are now supported and can be viewed in Excel Services.
Features that Previously Prevented Excel Files from Loading
In Office SharePoint Server 2007, Excel workbooks that contain unsupported features like VBA macros, form controls, and so on are not loaded in Excel Services.
![]()
In SharePoint Server 2010, to help users work with this limitation, Excel Services ignores certain unsupported features. In other words, rather than blocking the entire file from loading, Excel Services loads the file but you do not see the features that Excel Services does not support.
Following are features that do not prevent Excel Services from loading a file:
Note that these features continue to be unsupported. This means that they do not render, execute, or work in any way as they do on the client. Most of the features in the list do not render in Excel Services. For example, if there is a Shape near cell A1 when viewed in the client, you see no Shape when viewed on the server. Other features, like formula references and query tables, show values that were last refreshed on the client. In other words, the values in the cells are still there, but you cannot update them.
Lastly, VBA code does not execute on the server. In Office SharePoint Server 2007, Excel Services did not support loading *.xlsm files. In SharePoint Server 2010, Excel Services ignores VBA macros. Therefore, *.xlsm files can now be loaded in Excel Services.
Viewing a File with Ignored Features
If Excel Services is able to load files and not render certain unsupported features, how can you know the file that you are viewing is missing some features? You know that you are viewing a file with some missing features because Excel Services displays a notification above the worksheet to alert you. The following screenshot shows the notification.
Unsupported Features notification on top of workbook
This notification is the first indication that the file is rendering differently than it would in the Excel client.
In the following figure, clicking Learn more about unsupported features provides information about which unsupported features are in the file.
Unsupported feature error message for VBA
Cropped images are not displayed (that is, missing features).
Note
For workbooks that contain ignored or missing unsupported features that loaded in view mode with a notification bar, attempting to save a copy of the workbook involves removing the unsupported features. A dialog box alerts the user of this.
Other Unsupported Features
All other unsupported features continue to behave as they do in Office SharePoint Server 2007 for Excel Services. That is, Excel Services blocks loading of a file if it detects the existence of one or more of these unsupported features. Users are informed that the file cannot be loaded, as shown in the following screen shot.
Note
The Unsupported Features in Excel Services topic contains more details about these unsupported features.
Warning
The information bar with the list of unsupported features is not displayed if the file is loaded from a web part.
Unsupported feature error message for XML maps
Unlike workbooks with external links, charts with external links are blocked from loading.
See alsoConceptsOther resources![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |