How is DataSnipper-generated data sorted in workbooks

Step-by-step guide

1. Select the range you want to sort in Excel.

2. Start your sort (for example: Data tab → Sort).

3. If the range contains snips and the sort would move them, a dialog appears.

4. Choose one:

   • Update Snip references → moves snips to follow the sorted data.

   • Sort values only → sorts the cells but leaves Snips where they are.

5. Tick Apply this choice for this workbook session if you want the same option to be used automatically for the rest of this session.

6. Click on the relevant button in the pop-up to proceed.

7. If you choose to apply this choice for this workbook session, your choice will be used automatically for future sorts in this workbook until you close Excel — no pop-up will appear.

8. To set a workbook default (no pop-ups at all), open DataSnipper → Workbook Settings, find Snip sorting, and choose one:

   • Always ask me (default) — shows the pop-up when a sort would move Snips.

   • Always sort with references — moves Snips with the sort, no pop-up.

   • Always sort values only — sorts cells only, leaves Snips in place, no pop-up.

9. To change or clear your choice during the session, go to Workbook Settings → Snip sorting and select a different option or Always ask me.

10. After you reopen Excel, the workbook will return to Always ask me. If you want automatic behavior again, either set it in Workbook Settings or tick Apply this choice for this workbook session the next time the pop-up appears.