How to not lose snip references by sorting

By default, snips cannot be sorted in Excel, this could lead to cells connected to the wrong snip. This can be prevented by copying-pasting the snips, and sort the copy pasted snips.

Before you sort, please select the full table you want to sort, use copy (CTRL + C), and then paste (CTRL + V) to create referenced snips in a new sheet. Now you can sort the pasted area without losing the snip connections.

Sorting snips directly within excel leads to loss of references, which can only be reconnected if you can sort back to the original sorting for example through an index column.