How to prevent a table (or a worksheet) from sorting (and that's it)|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi Scotty,

If you have Excel 2013 or later you can use Slicers with Tables for filtering. You can then turn off the Filter buttons on the Table header to reduce the likelihood of it being sorted via those buttons, but you can't use protection as this also prevents the Table automatically expanding.

You could always add an Index column that numbers the rows in the order you want to retain, then if someone does sort it you can sort it back to its original state using the Index column.

Your only other option I can think of is to use VBA.

Mynda