What's new: Microsoft Office Add-in features
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
We have changed and added functionality to the Office Add-ins for Microsoft Dynamics AX feature area for Microsoft Dynamics AX 2012. For more information, see the table that applies to your version of the product.
For more information, see Integrating Microsoft Dynamics AX with Microsoft Office in the Microsoft Dynamics AX 2012 Technical Library on TechNet. For more information about the Office Add-ins API, see Using the Office Add-ins API on MSDN.
What’s new in AX 2012
What’s new |
What’s new |
|---|---|
Integration with Microsoft Word is supported by Microsoft Dynamics AX. |
This new feature lets you use Word to build templates and documents that combine structured and unstructured information from Microsoft Dynamics AX. For more information, see About using the Microsoft Dynamics AX Add-in for Word. |
View and update data from Office tools. |
You can use the Add-ins for Microsoft Excel and Word to view and analyze information in Microsoft Dynamics AX. You can use the Add-in for Excel to update information in Microsoft Dynamics AX. For more information, see About using the Microsoft Dynamics AX Add-in for Excel. |
More enhancements to the integration with Excel are supported by the Microsoft Dynamics AX add-in. |
The enhancements to this feature let you update data from Excel by using web services for Microsoft Dynamics AX Application Integration Framework (AIF). An opt-in checklist for built services is also available. For more information, see Use Microsoft Excel to import and export data. |
What’s new in Microsoft Dynamics AX 2012 R2
What’s new |
Description |
|---|---|
Add descriptions to financial dimensions. |
When you create an Excel workbook by using the Office Add-ins, you can add descriptions of financial dimensions to the ledger accounts that you select for the workbook, such as when you create a budget template. For more information, see Create budget plan templates manually. |
Lock a template that is created by using the Office Add-ins. |
In budget planning scenarios, a partner or central administrator designs and deploys budget templates, and department leads or other personas fill in the numbers. To reduce the chance of error, the template designer can lock a template. This lock is not a security constraint. Template users can enter data into the locked template but cannot modify the template structure. For more information, see How to: Use Office Add-ins to Lock an Excel Spreadsheet. |
Filter a workbook. |
When you create a workbook by using the Office Add-ins, you can add filters to the data in the workbook. Users of the workbook can then view only the data that is selected in the filters. Additionally, you can add a readonly property to selected fields in the field list of the workbook. For more information, see How to: Add an Office Add-in Filter to a Spreadsheet. |
Localize data in the Office Add-ins. |
The Office Add-ins for AX 2012 R2 respect the current language setting of Microsoft Dynamics AX for the current user. A worksheet that was created by using the Office Add-ins matches the language selection, and labels in the workbook are displayed in the same language. |
What’s new in cumulative update 7 for Microsoft Dynamics AX 2012 R2
What’s new |
Description |
|---|---|
Improved performance when you use the Office Add-ins |
When you modify data that you exported from AX 2012 into an Excel workbook, and you then import the data back into Microsoft Dynamics AX, the import process requires less time. For more information, see Use Microsoft Excel to import and export data. |
Validate dimensions. |
In the Add-in for Excel, a new Validate dimensions button helps you locate and correct financial dimensions that were entered incorrectly or that are suspended. This feature helps you perform tasks such as budgeting for dimensions. For more information, see Set up financial dimensions for integrating applications (Excel and Management Reporter) and Create budget plan templates manually. |