Hi
I have a table in Excel 2016 that gets its data via OLE DB connection from a back end database.
I have manually added an extra column "Comments" into the table so that I can add my own comments in the local Excel file related to each row in the table.
However, when I refresh the connection it pulls in the latest data from the back end database as desired - but the comments added relevant to the rows do not move and stay back in the same cell where they were first inserted.
Is there a way to move the cell (with the comment) along with the row where its intended to be, as it can be confusing when it reflects against some other row?
Thanks for any suggestions here.
PC
Bookmarks