Fix Missing Excel Comments After Moving a Workbook Online
Question details
The user needs to recover Excel comments that are missing after a workbook is moved online.
- Product
- Microsoft Excel desktop and Excel for the web
- Device & OS
- not provided
- Scenario
- A workbook containing threaded comments or legacy notes was moved online, and the user wants the comments to appear correctly in Excel for the web.
- Observed behavior
- Excel for the web does not open or display some comments, potentially because of workbook corruption, incompatible comment storage, or incomplete cell copying.
Confirm whether the missing annotations are threaded comments or legacy notes, and make a separate copy of the workbook before attempting repair. Keep the original file available so you can compare the repaired worksheet with the source.
Repair the workbook and copy the complete worksheet into a clean file
Use this method when Excel reports corruption or comments disappear after the workbook is uploaded to Excel for the web.
Desktop Excel can repair damaged workbook structures before the file is uploaded again. Copying the entire worksheet into a new workbook is safer than copying only selected cells because comment metadata may not transfer with partial selections.
Launch Microsoft Excel, select File > Open > Browse, and open the affected workbook from your computer. If Excel displays a repair notification, choose Yes or Repair to let Excel recover the file.
In Excel, select File > New > Blank workbook to create a new file. Return to the repaired workbook, right-click the affected worksheet tab, choose Move or Copy, select the new workbook in the To book list, and select Create a copy before clicking OK.
In the clean workbook, select File > Save As, choose the Excel Workbook (*.xlsx) format, and save the file with a new name in a local folder.
Go to OneDrive or SharePoint, upload the new .xlsx file, and select Open in Excel for the web. Check the worksheet cells for the recovered comments and notes.
Copy the used range with Office Scripts when a full worksheet copy is not practical
Use this option for a large or structured workbook when you need to transfer the complete used range programmatically.
Use WPS Office as a lightweight Excel workbook alternative
WPS Office provides a free, lightweight spreadsheet editor with a familiar interface and strong Microsoft Office format compatibility. Open or rebuild the affected XLSX workbook in WPS Office, then use the repaired file as part of a seamless migration when Excel for the web cannot display the original comments reliably.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or Applications folder.
- 2. Open the workbook: Select Menu > Open, choose the affected .xlsx file, and inspect the worksheet content and available comments or notes.
- 3. Save a clean copy: Select Menu > Save As, choose the Excel 2007-365 (*.xlsx) format, and save the workbook with a new file name.

Frequently Asked Questions
Why do Excel comments disappear after a workbook is moved online?
Threaded comments and legacy notes use different storage formats, and corruption or incomplete copying can prevent Excel for the web from reading their metadata. Repair the file in desktop Excel and copy the complete worksheet into a clean workbook.
Should I copy individual cells to restore missing comments?
No. Individual cell copying may omit comment metadata. In desktop Excel, right-click the worksheet tab, choose Move or Copy, select a clean workbook, and copy the entire worksheet instead.
Can Excel repair a workbook that will not display comments online?
Often, yes. Open the file in desktop Excel through File > Open > Browse. If Excel shows a repair prompt, allow the repair, save the repaired workbook as a new .xlsx file, and upload that copy to Excel for the web.
Can Office Scripts copy comments from one worksheet to another?
Office Scripts can copy the complete used range with Range.copyFrom and the all copy option, but threaded comments and legacy notes may not transfer identically. Verify the result in Excel for the web after running the script.
Is it safe to edit threaded-comment XML manually?
No. Manually changing comment XML or workbook metadata can make the file unreadable online. Use desktop Excel repair, a full worksheet copy, or an Office Script instead.




