'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Stop Excel 365 from Changing Note Format and Content
Question details
The user needs to prevent Excel 365 from automatically converting formatted notes into abnormal text strings.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Opening, editing, or migrating workbooks that contain legacy notes or modern comments.
- Observed behavior
- Excel unexpectedly changes formatted notes into raw text beginning with a specific pattern, such as '====== ID#AA...', often due to conflicts during the transition between legacy notes and modern comments.
Before proceeding with any troubleshooting steps, ensure you have saved a backup copy of your affected workbooks and closed all active Office applications.
Isolate and Disable Conflicting COM Add-ins in Safe Mode
This issue is frequently triggered by incompatible third-party add-ins interfering with Excel's rendering engine. Running Safe Mode allows you to identify the specific add-in causing the format change.
Excel's Safe Mode bypasses all custom settings and COM add-ins. If the notes display correctly in Safe Mode, a third-party extension is likely responsible for the text corruption.
Press the Windows Key + R to open the Run dialog box. Type 'excel /safe' and press Enter to launch Microsoft Excel in Safe Mode.
Open the affected workbook. Hover over or edit the cells containing notes to see if the '====== ID#AA...' text pattern still appears.
If the notes appear completely normal, go to 'File' > 'Options' > 'Add-ins' in the bottom left corner.
At the bottom of the window, change the 'Manage' dropdown to 'COM Add-ins' and click 'Go...'. Uncheck all boxes in the list and click 'OK'. Restart Excel normally to see if the issue is resolved.
Reset Office Settings via Registry Editor
If add-ins are not to blame, the problem may lie in corrupted backend settings related to the transition between legacy notes and modern comments. Resetting the Office registry key forces Excel to build fresh configuration files.
Avoid Excel Note Glitches with WPS Office
Tired of dealing with note formatting bugs and add-in conflicts in Excel 365? WPS Office provides a highly stable, lightweight, and completely free alternative for managing your spreadsheets without data corruption.
- 1. Download and Install: Visit the official WPS website to download the free suite and install it on your device.
- 2. Open Your Spreadsheets: Right-click your existing .xlsx files and select 'Open with WPS Spreadsheet' to securely load your data.
- 3. Edit Notes Securely: Navigate to the Review tab to view, add, and manage notes and comments safely without fear of formatting loss.
Frequently Asked Questions
What is the difference between Notes and Comments in Excel 365?
In modern versions of Excel 365, 'Comments' are threaded conversations designed for collaboration and replying, whereas 'Notes' are the traditional yellow sticky boxes used simply for adding annotations to a cell.
Why does my Excel note turn into a text string starting with '====== ID#AA...'?
This specific text pattern usually indicates corruption in how Excel renders legacy notes. It is almost always triggered by an incompatible third-party COM add-in that interferes with the spreadsheet's background XML structure.
Will renaming the Office registry key delete my Excel spreadsheets?
No. Renaming or resetting the Office registry key only reverts your application preferences (such as ribbon customizations and default views) back to their factory settings. Your personal workbooks and data will remain entirely unaffected.
