The Excel and SQL Server experts blog

SQL Spreads 6.0.30 is now available for download. This new release introduce a new feature to use the Tree filter selection as the key column when inserting new rows into a table. Added a new Parameter selection dialog to easily insert Tree Filter and Cell parameters. Added the possibility to remove key columns that are …

SQL Spreads 6.0.17 is now available for download. SQL Spreads 6.0 introduces the new Lookup feature to easily lookup key values from a related table or a list of fixed key-text pairs. A drop-down list in Excel allows the user to select a text item, while the corresponding key will be written to the database. …

SQL Spreads 5.1.12 is now available for download. Added support for using key columns with the UNIQUE IDENTIFIER data type while also generating new IDs as a default value in SQL Server. Fixed issue with Designer being locked for new worksheets in certain cases. Minor bug fixes Download the latest version of SQL Spreads »

SQL Spreads 5.1.07 is now available for download. The Excel table is now always resized to the number rows that are imported from the database. Added support for using SQL Server columns with the data type DateTimeOffset. Conflict detection will now work over different time zones when setting the ModifiedOn Change Tracking column to a …

SQL Spreads 5.0.55 is now available for download. SQL Spreads 5.0 is the largest SQL Spreads update in over two years with several long-wished features and improvements such as data pivoting, the table creator and database, and table search. Introducing the new Pivoting feature to update pivoted data in columns in Excel into rows in …

SQL Spreads 4.50.148 is now available for download. Fixed issue with changing the SQL Server server name (the text field was disabled) when opening a document when the SQL Server instance is not accessible. Fixed issue with conflict detection not saving non-conflicting rows correctly. Fixed issue with checking the license on the server if a …

SQL Spreads 4.50.139 is now available for download. With this release, we are introducing a new license system that supports online activations and a lot of new features on the deployment and installation side. With the new online activations, there is no need to manually activate the licenses through emails. If you are an existing …

SQL Spreads 4.4.7 is now available for download. Fixed issue when working with protected Excel worksheets. Fixed issue with conflict detection giving an error under certain circumstances. Download the latest version of SQL Spreads »