Hi all
I have a SharePoint list exported to Excel – and I’ve appended some Excel columns with some comments which I have to keep local on an Excel file and can’t go into the original SP list.
This works ok except when the SP list columns in Excel are sorted and then refreshed – which leads to all the local comments swapping around to different rows.
I’ve looked this up and it seems that it’s a problem if the SP list is sorted before it’s refreshed
Does anyone have a solution for either:
(A) Preventing the local comments from swapping around upon refresh,
…or…
(B) Preventing the whole table from being sorted? This is to always keep the table sorted by ID. I’d need to retain the option to filter but we can live with just disabling the Sort option.
I had tried this through sheet protection (only stopping Sorting), but it prevented the whole Export from refreshing from the source data SP list - so would need an approach to either protecting the sheet which allows the SP-connected columns to refresh, or another way to prevent sorting.
Unfortunately, just 'don't sort the table' isn't going to work as I'm ultimately not going to own this table in the end!
For reference, this is how external data properties is set up:
Any solutions are appreciated!
I have a SharePoint list exported to Excel – and I’ve appended some Excel columns with some comments which I have to keep local on an Excel file and can’t go into the original SP list.
This works ok except when the SP list columns in Excel are sorted and then refreshed – which leads to all the local comments swapping around to different rows.
I’ve looked this up and it seems that it’s a problem if the SP list is sorted before it’s refreshed
Does anyone have a solution for either:
(A) Preventing the local comments from swapping around upon refresh,
…or…
(B) Preventing the whole table from being sorted? This is to always keep the table sorted by ID. I’d need to retain the option to filter but we can live with just disabling the Sort option.
I had tried this through sheet protection (only stopping Sorting), but it prevented the whole Export from refreshing from the source data SP list - so would need an approach to either protecting the sheet which allows the SP-connected columns to refresh, or another way to prevent sorting.
Unfortunately, just 'don't sort the table' isn't going to work as I'm ultimately not going to own this table in the end!
For reference, this is how external data properties is set up:
Any solutions are appreciated!