• The Excel and SQL Server experts blog
  • SQL Spreads release 4.3.0

    Johannes Åkesson - Oct 25, 2018

    SQL Spreads 4.3.0 is now available for download.

    This release adds a few new features and also improves working with data in Azure SQL.

    • Added support for working with contained databases, where the default database must be specified.
    • Added the Formula Row feature to be able to add summary rows within an Excel range that is synced with a SQL Server table.
    • Improved support for filtering data based on user when SQL Authentication is used. Mainly for Azure SQL implementations.
    • Improved support for inserting rows into Views with a base table having an Identity Key.
    • Improved seamless installation on both 32-bit and 64-bit Excel.
    • Fixed issue with Filter and Sort tabs in the Designer not being shown if Excel is updated to a July 2018 release and Windows is still on an earlier release.
    • Fixed issue with editing Excel workbook embedded into Word.
    • Fixed issue with default database not cleared when a new database is selected.
    • Fixed issue with conflict detection when the data in the database is set to a date before 1900-02-26.
    • Fixed issue with check for VSTO Runtime during installation.

    Download the latest version of SQL Spreads »

    Comments are closed.

Use Excel to update your data in SQL Server?

Try the SQL Spreads data management solution to update and manage your SQL Server data from within Excel.