Hi
I have a SharePoint list exported to an Excel table which I'd like to keep as a live connection by using Data > Refresh All.
I'd like to lock the table so it cannot be sorted, but that it can still be filtered. I tried this through Sheet Protection (only blocking sorting but allowing everything else) but protecting the sheet prevented the Data from being refreshed. I just get an error saying "The cell or chart you're trying to change is on a protected sheet".
Does anyone know of a way to prevent the table from being sorted - but which will still allow (a) the data connection to be refreshed and (b) the option for the table to be filtered?
I have a SharePoint list exported to an Excel table which I'd like to keep as a live connection by using Data > Refresh All.
I'd like to lock the table so it cannot be sorted, but that it can still be filtered. I tried this through Sheet Protection (only blocking sorting but allowing everything else) but protecting the sheet prevented the Data from being refreshed. I just get an error saying "The cell or chart you're trying to change is on a protected sheet".
Does anyone know of a way to prevent the table from being sorted - but which will still allow (a) the data connection to be refreshed and (b) the option for the table to be filtered?