SharePoint Linked Table, Add columns in Excel

Hi All,

I have exported a SharePoint list to excel, no problems

I have then added extra columns in excel (not to the SharePoint List)

So Columns A to G is the SharePoint List linked table, and I have manually entered data into Column H

When I refresh the data from SharePoint, A new list item may be added, thus expaning the table in excel, however the data I have put in column H does not move

Example: Cell A20 has a name in it, "David", cell H20 has a note about David, "David is absent"

once i refresh my table, after one new list item has been added, "David" is pushed down to cell A21, however my note stays in cell H20

Is there a way to stop this?

Thanks in advance for any replies

Hi, I have precisely the same question.
Would love to know if you found a solution?
Thank you.