Office Insider for Windows version 2202 release notes.

Build 14912.20000 (January 21, 2022)

Excel

Improved Power BI-connected PivotTables

Many users have requested improvements for PivotTables connected to Power BI datasets, enabling easy drag-and-drop aggregations by dragging fields into the Values area of the PivotTable. Now they’re here! This work builds on recent improvements that make it easier to create Power BI-connected PivotTables without having to leave Excel. 

Learn more

Word

Notable Fix

• We fixed an issue where an error appeared on closing any document containing a list style with the “New documents based on this template” option enabled.

Outlook

Notable Fixes

• We fixed an issue where the list of folders in Outlook stopped responding to mouse clicks after a contact profile card was opened.
• We fixed an issue where a hyperlinked URL didn’t change automatically when there was a change in the shared OneDrive link using Outlook.

Access

Notable Fix

• We fixed an issue where some SQL Server drivers would show the error “String data, right truncation (#0)” when a user tried to add more than 8,000 bytes worth of data to a varchar(max) field.

Office Suite

Notable Fix

• We fixed an issue where some default applications disappeared after the monthly Office update.

January 14, 2022 | Version 2202 (Build 14907.20000)

Word

Improved coauthoring error recovery experience

Collaborating with others while working in Word is a vital productivity tool for many users, and disruptions can be extremely frustrating. We’ve now developed an improved recovery experience to quickly restore users back to a connected state after experiencing coauthoring errors. This automatic refresh synchronizes all changes among different authors, so you’re seeing the most up-to-date document possible.

Notable Fix

• We fixed an issue that caused the app to close unexpectedly when selecting Go to Comment for the first comment in a document.

Outlook

Send emails from a proxy account

You asked for it! Outlook has traditionally supported receiving email at addresses other than your default address (known as a proxy address, or alias). Now you can send mail from those proxy accounts as well by choosing the desired outgoing address. To use this feature, click Home > New Email. In the message window, click the arrow on the right side of the From button and choose Manage List. You can then add additional From addresses to the dropdown menu. Once that’s done, click the address you want to send the email from (via the From menu). Compose your email, and then click the Send button. Note that your tenant admin must enable this feature to make it available to users.

Notable Fixes

• We fixed an issue with Outlook Search that caused incomplete results when using the OnPrem service search.
• We fixed an issue where a message using Digital Rights Management (DRM) could not be opened.

Excel

Facilitate your data validation with AutoComplete for dropdown lists

Dropdown lists are a handy way to make data entry and validation more efficient in Excel. We’ve now added AutoComplete functionality, which automatically compares the text typed in a cell to all items in the dropdown list and displays only the items that match. You’ll spend less time scrolling through lists, dealing with data validation errors, or writing complex code to handle this task.

PowerPoint

Notable Fix

• We fixed an issue where linked images might not load when opening a presentation programmatically in window-less mode.

Access

Notable Fix

• We fixed an issue that would prevent multiple users from opening a database when using network paths that include DFS Namespaces, short file names, or mapped drives. Learn more

Word, Excel, PowerPoint

Notable Fix

• We fixed an issue with SVG files exported from Visio not displaying text correctly.