Fix Excel Notes Columns Moving After a SharePoint Refresh
Question details
The user needs notes to remain associated with the correct SharePoint records when an Excel data table is refreshed.

- 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.
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.
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.
Open the source list in SharePoint, select Add column, and create a Notes column using a text type appropriate for your 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.
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.
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.

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.

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.




