I am trying to set up my system to only save, and load, selected cells. I understand that I can select specific cells, right click, and add them to the list, however, I have 2 worksheets that contain tables, that can grow to any size, so whenever I select the full columns (A:E) for example, right click, and click “Let users save and restore selected cell”, the system hangs - is this because there is a limit on the number of cells you can add, and if so, can I specify complete columns or worksheets somehow?
The system can hang if you use cell data validation for instance, with lots of cells. The documentation has an example about storing an entire column. But if you want to store entire worksheets, then the full save mode is better.