Sunday, August 1, 2021

Office add ins compatibility issues

The Compatibility Checker found one or more Office Add-in-related compatibility issues.

Note: New name for apps for Office - Office Add-ins. We are currently updating our products, documentation, samples, and other resources to reflect the platform name change from "apps for Office and SharePoint" to "Office and SharePoint Add-ins". We made this change to better distinguish the extension platform from Office apps (applications). While these changes are taking place, the dialogs and messages you see in your application might be different than what you see in this article.

Important: Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality.

Issues that cause a significant loss of functionality

Issue

Solution

The workbook contains a task pane add-in.

What it means    Task pane add-ins can be saved only to the Office Open XML file formats, and are removed when you save the file to other formats. Any data in the worksheet that the add-in uses remains intact. Any cells that contain results from a task pane are saved with the value shown in the cell before the file is saved to the earlier file format.

What to do    Consider recreating the functionality of the task pane add-in; for example, by using cell formulas, objects, or external data references.

The workbook contains a content add-in.

What it means    Content add-ins can be saved only to the Office Open XML file formats, and are converted to pictures when you save the file to other formats.

What to do    Some content add-ins are charts, so you could replace the add-in with a chart that's supported in earlier versions of Excel. Consider replacing other types of content add-ins with an object connected to VBA code that will work in earlier Excel file formats.

No comments:

Post a Comment