You can soon have the ability to disable specific types of automatic data conversions in Microsoft Excel. With the latest insider update (Microsoft Office version 2207, Build 15427.20000), Microsoft previewed this feature with tons of fixes as listed below. If you are an Office Insider in the Windows Beta Channel, you would like to upgrade to this build to try it out before the general availability.

 

You can soon control your data conversions in Excel

 

What's new and improved in Microsoft Office version 2207, Build 15427.20000

Control your data conversions in Excel

You’ve been asking for more control over how Excel automatically converts your data to specific formats. We delivered! You now have the ability to disable specific types of automatic data conversions; this way, you won’t need to worry about Excel converting your data to a format that you didn’t want and weren’t expecting. To do so, just select File > Options > Advanced > Automatic Data Conversion and choose the conversion(s) that you’d like to disable.

 

 

Other improvements and bug fixes

  • Fixed an issue where, in certain cases, some parts of the background of the formula bar would incorrectly show as white when opening a workbook after starting Excel with the Start screen disabled.
  • Fixed an issue where protected labels stopped working when the user reopened the app immediately after saving and closing.
  • Fixed an issue where cell references in charts were displaying incorrectly.
  • Fixed an issue that was preventing the Room Finder from loading in the GCC High environment.
  • Fixed an issue where, if a user’s default link permission type was set to “specific people,” permissions on a link inserted using Outlook’s Insert Link option were not granted to the recipients as intended (and an error could be generated).
  • Fixed an issue where the app would erroneously create a new group configuration for the additional Exchange accounts in the profile.
  • Fixed an issue where the app would close unexpectedly if a user double-clicked on the Tentative response button for a meeting from the reading pane when responses were not requested.
  • Fixed an issue where the user interface sometimes stopped rendering on ARM64 devices.
  • Fixed an issue that occurred when applying 3D effects to pictures in the app.
  • Fixed an issue that was causing the app to not refresh correctly.
  • Fixed an issue where the app would close unexpectedly when saving a file as an Adobe PDF.
  • Fixed an issue where the content was being hidden when the user double-clicked to hide white space.
  • Fixed an issue where the footer added by built-in labeling incorrectly moved existing, manually added footers.
  • Fixed an issue that was causing the app to close unexpectedly.
  • Fixed an issue where, after inserting a shape or line onto the canvas, the cursor didn’t change when the shape or line was selected for moving or resizing.
  • Fixed an issue where changes to custom document properties were not always reflected in the user interface.
  • Fixed an issue where Table Style Options were sometimes incorrectly disabled with Information Rights Management.
  • Fixed an issue that occurred while attempting to support Unicode characters in the unique identifier column.
  • Fixed an issue that occurred when applying 3D effects to pictures in the app.
  • Fixed an issue where the app would close unexpectedly when using ink to do the math.
  • Fixed an issue where background uploads for CLP-protected files led to data loss or protection loss in some cases.
  • Fixed an issue where, when working in files stored in SharePoint Online or OneDrive, the CPU memory incremented until it was consuming the machine’s entire capacity.
  • Fixed an issue where the ribbon options menu wasn’t rendering in Excel.
  • Fixed a visual glitch in Office apps that occurred when opening the Backstage by clicking the File tab.
  • Fixed an issue where cropped images were displaying as blurred in Print Preview.
  • Fixed an issue so that SVG formats from Adobe and Inkscape are properly recognized and inserted.
  • Fixed an issue affecting the recognition and insertion of SVG files from various websites.
  • Fixed an issue so that online users of the coauthoring feature would be informed when a sensitivity label that they don’t have permission to access is applied by another user.
  • Fixed an issue where, when opening Excel files stored on OneDrive and SharePoint Online, the app would close unexpectedly, and data loss could occur.

 

Have a question? Or, a comment? Let's Discuss it below...

Thank you for visiting our website!

We value your engagement and would love to hear your thoughts. Don't forget to leave a comment below to share your feedback, opinions, or questions.

We believe in fostering an interactive and inclusive community, and your comments play a crucial role in creating that environment.