My Table Handles are not working

When you open a spreadsheet which contains Table Handles, they need to be recalculated before they can be used. The Table Handles represent data captured from the spreadsheet or loaded from the PersisTables store. To load the data into the Handle, the formula they contain needs to be recalculated.

In this trivial example the yellow range is the original data which is captured inthe ‘Data’ Handle and then displayed in the Green area. G10 shows the current time using Now() while The Handle contains the time it was last calculated.

Closing and reopening the spreadsheet shows the same data and Handle time but Now() has been updated

If we try and recalculate the data in the green area it all goes wrong

The Handle is stale because it has not been recalculated since it was loaded.
The answer is to regenerate the Handle either by pressing [F2] followed by [Enter] or recalculating the whole workbook using the key combination [CTRL][SHIFT][ALT][Enter] together.

We can see that the timestamp on the Handle now matches the current time showing it is up to date. We can now manipulate the Table data as before.