File Corruption & Recovery

Fix Missing Excel Comments After Moving a Workbook Online

Kushani NimanthikaKushani Nimanthika Nov 12, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in desktop Excel

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.

2
Create a clean workbook

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.

3
Save the repaired workbook

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.

4
Open the clean file online

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.

Use the complete worksheet: Copying the whole worksheet preserves more workbook information than selecting and copying individual cells. Avoid manually editing threaded-comment XML or other workbook metadata.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or Applications folder.
  2. 2. Open the workbook: Select Menu > Open, choose the affected .xlsx file, and inspect the worksheet content and available comments or notes.
  3. 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.
Open and edit Excel XLSX workbooks with a familiar spreadsheet interface.Use a lightweight alternative when you need to inspect or rebuild workbook content locally.Maintain compatibility with Microsoft Excel XLSX files during migration.Work with Writer and Presentation files alongside spreadsheets in one Office suite.
microsoft office alternative - wps office

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.