Product Releases

October 2010 - Version 3.2

• Enable use with Excel 2010
• Improved handling of statistical functions such as STDEV
• Correct handling of locked data cells for *.xlsx spreadsheets, including correct color-coding on Advanced screen
• (Version 3.2 now available from our Download and Purchase pages)

May 2010 - Version 3.1

• Enable encryption of ROW and COLUMN functions
• Enable proper calculation of HLOOKUP, VLOOKUP functions where third parameter is a cell reference rather than a constant
• Improve Document Sentry default startup behaviour and defaults
• Eliminate repeated cell calculation error messages
• Reduce number of "encrypted formula too long" errors
• Improve treatment of encrypted named variables

December 2009 - Version 3.0

• Encode Excel 2007-format files (.xlsx, .xlsm)
• Improve reading and display of cells containing 'problematic' formulations
• Include Document Sentry as part of standard distribution (also available separately) - new utility for encrypting entire files
• (First Spreadsheet Sentry-branded version)

November 2009 - Version 2.3

• (Final ExcelSentry-branded version)
• Check that correct version of Excel is available prior to Encoder using it
• Increase range of circumstances allowing movement of hidden cells
• Allow additional functions using range precedents containing hidden cells
• Improve flexibility of permitted parameters to a function with hidden precedents

September 2009 - Version 2.2

• Beta Personal version that reads Excel 2007-format files (.xlsx, .xlsm) now available on request
• Multiple encoding options for network authorization
• Suppress repeated password requests when multiple spreadsheets are open

July 2009 - Version 2.1

• Allow use of Client with 64-bit operating systems
• Improve Client recalculation speed with hidden data
• Improved handling of cells that are unable to be encrypted  

March 2009 - Version 2.0

• Audit facility that will check for integrity of encrypted formulas
• Option to hide data display values
• Option to encrypt data cells
• Network authorization control (requires Network Authorization Server)
• Improved handling of Excel4 macro sheets
• Improved encryption algorithm
• Version 1 compatibility mode
• Updated user interface, improved color-coding on Advanced screen viewer
• Default user global options in configuration file

November 2008 - Version 1.5

• Improve include/exclude encoding of ranges
• Allow save and load of Advanced settings for a particular spreadsheet 
• Fully allow for Excel shared formulas   

July 2008 - Version 1.4

• Selection of ranges to include or exclude from encoding
• Visual display of cells to be encoded on Advanced screen 
• Permit encoding of template files
• Place encoding notification in File>Properties>Comments

January 2008 - Version 1.3

• Simultaneous release of ExcelSentry Personal Version 1.3 , which is provided free for non-commercial use (encoded spreadsheets can only be used on Encoder PC)
• Permit easier operation by user with limited folder access rights (e.g. standard user under Vista)
• Various user interface improvements, including more useful display of cell contents on Advanced screen
• Allow encoding of worksheets that are already password-protected
• Operates correctly with Excel 2007 (provided spreadsheet to be encoded is compatible with Excel 2003) 
• Improved handling of multiple open spreadsheets (Version 1.2.1)

July 2007 - Version 1.2

• New formula encryption option that allows "structural" updates to be made to the encoded spreadsheet, including: 
  • movement of precedent data cells
  • movement of encrypted formulas
  • inserts and deletes of columns and rows
• Updated license management, making it easier to activate licenses on remote PCs
• Improved handling of some less common formula constructions

March 2007 - Version 1.1

• Automatic unlocking of data cells for fully-locked workbook
• Updated encryption parameters
• Improved license activation procedures

December 2006 - Version 1.0

• First version released for general use
• Wizard-based user interface