We have changed the download process for PersisTables. You can now download directly from the website here. The installation package will be downloaded by your chosen browser and opening it will cause the auto-extract and install process to start. There is a chance that your anti-virus software will object, you should enable the download process […]
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 […]
Excel functions are great when they have to return a single value, SUM(), MAX(), LEFT() all return the results of their processing into the cell the formula is entered in. What happens though when the formula needs to return multiple results? The Array Formula is designed to handle just such a situation. It allows the […]
In an earlier blog post I discussed how PersisTables simplifies the creation of a CSV file. In the post I created a Table and then used the TKTable_Save() function to save it away. One of the powerful features of PersisTables is that a Table and an Excel Range are interchangeable. So any function that accepts […]
There are two versions of the PersisTables installer package, designed to work with 32 bit or 64 bit versions of Excel. This should not be confused with using 32 bit or 64 bit Windows versions (all versions of Windows beyond Windows 7 are 64 bit). To check which version is required open Excel, click on […]
The simplest way to find the expiry date is to open the Persistence Viewer by right clicking on an empty cell and selecting it. The TKTable_Version() function also provides details on the installation including the expiry date for the current license. Here the contents of the version table has been expanded using TKTable_Get(). The License […]