SharePoint Document Issues

Fix Excel Notes Columns Moving After a SharePoint Refresh

Nimra MalikNimra Malik Nov 22, 2026 868 views

Question details

The user needs notes to remain associated with the correct SharePoint records when an Excel data table is refreshed.

Fix Excel Notes Columns Moving After a SharePoint Refresh
Product
Microsoft Excel and SharePoint Lists
Device & OS
not provided
Scenario
An Excel workbook contains a table linked to a SharePoint list, with an additional Notes column created only in Excel.
Observed behavior
After records are added or the SharePoint data is refreshed, Excel-only notes can become mismatched with their original records.
Before you start

Check that you have permission to add a column and edit items in the SharePoint list. Identify a stable record identifier, such as the SharePoint ID, and verify which notes belong to which records before transferring them.

Solution 1Recommended

Store the Notes column in the SharePoint list

Use a SharePoint list column to keep each note with its source record when Excel refreshes the data.

An Excel-only column is not part of the SharePoint source, so its values cannot reliably retain their record associations when the imported rows change.

1
Add a SharePoint column

Open the source list in SharePoint, select Add column, and create a Notes column using a text type appropriate for your notes.

2
Enter verified notes

Open or edit each SharePoint list item and enter its note in the new Notes column. Use the item ID and any verified records to confirm the correct association; do not assume an already-misaligned Excel row is correct.

3
Include the column in Excel

In Excel, check the SharePoint data query or connection and ensure it includes the new Notes column. If the query selects specific columns, edit it through Data > Queries & Connections to include Notes.

4
Refresh and verify

Select Data > Refresh All in Excel, then compare several Notes values and their record IDs with the SharePoint list. Once verified, remove or clearly distinguish the old Excel-only Notes column to avoid confusion.

Store the Notes column in the SharePoint list
Existing notes may need review: Refreshing does not automatically repair notes that were already assigned to the wrong rows. Verify their original associations before entering them in SharePoint.
Free Microsoft Office alternative

Review SharePoint Spreadsheet Exports with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Microsoft Office files. Open an Excel export in WPS Spreadsheets to review records and notes as you move between office suites. WPS does not fix Excel's SharePoint refresh behavior.

Review exported spreadsheet records and notes in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsFree and lightweight for everyday spreadsheet workOpen existing Office files to make migration easier
microsoft office alternative - wps office

Frequently Asked Questions

Why do my notes move when I refresh the SharePoint data?

A Notes column created only in Excel is not connected to the SharePoint list items. When the refresh changes the imported rows, Excel cannot reliably keep those notes associated with their original records.

How do I make notes part of the SharePoint data?

Open the source SharePoint list, select Add column, and create a Notes text column. Enter each note on the correct list item, then include the column in the Excel query and select Data > Refresh All.

What if the new Notes column does not appear in Excel?

Check Data > Queries & Connections in Excel. If the query selects specific columns, edit it to include Notes, then refresh the data. Also check that the column is available in the source list or view used by the connection.

Will refreshing put mismatched notes back on the correct rows?

No. Refreshing cannot determine which record an Excel-only note originally belonged to. Use SharePoint item IDs and verified records to establish the correct associations before entering the notes in the source list.