Understanding 'Designer' and 'Data User' mode

The idea behind the Designer and Data User modes is that you should be able to let a person with database knowledge create an Excel spreadsheet for data maintenance, and then let your non-database skilled people work with the data through Excel.

In Data User mode, all SQL Spreads Design-features in Excel will be locked down, and the user can only do changes in the data, not in the setup of the connection from Excel to SQL Server.

You are free to select if you should activate your SQL Spreads license in Designer or in Data User mode. You select which mode to use by activating either the Designer or the Data User key that was delivered in the email after purchase.

Feedback and Knowledge Base