Sharing SQL Spreads Excel documents
  • Dark
    Light
  • PDF

Sharing SQL Spreads Excel documents

  • Dark
    Light
  • PDF

You share your SQL Spreads Excel document like any other Excel file. Just ensure that the user has the SQL Spreads Excel Add-In installed, and then send them the file either by email, on a shared drive or through a SharePoint site.

When working with a team of users, SQL Spreads can be installed in Data Editor mode for those users who should only be able to update and manage the data in SQL Server.

Sharing your SQL Spreads Excel document

You can share your SQL Spreads Excel documents as any other Excel file by email, using a shared folder or using SharePoint.

Using a shared drive

SQL Spreads supports working with SQL Server data in Read-Only Excel files, so you can have multiple end users using the same shared file in read-only mode to update and manage the data in SQL Server.

Using SharePoint

If you have multiple end users downloading and updating an Excel document from a shared location such as SharePoint, you can implement the following solution to prevent issues with duplicate lines or no changes being saved due to the new rows being transferred to the new users before they are saved to the database. This only applies to when you are working with your document in the co-authoring mode.

  1. The Designer/Creator of the document will need to check-out the Document in SharePoint:
    Check-out Excel file from shared location

  2. The end-user can then open the document in the Read-Only view:
    View Read-only Copy

As SQL Spreads does support working with SQL Server data in Read-Only Excel files, the end-user can use the read-only file to update the data in SQL Server.

Updating your SQL Spreads file from SharePoint

You will always need to download the Excel file to your desktop from your SharePoint location before being able to make any changes to the document, and then upload it again. The file will not be editable in the web version of SharePoint.

Protecting your setup

There are two ways to prevent your users from making changes to the setup you have created in the SQL Spreads Designer;

  1. You can install SQL Spreads in Data Editor mode where all the Design features are locked out.
  2. You can password protect the Design mode if you are sharing your document with a user who is running SQL Spreads in Design mode.

Disable the Design Mode for end-users

For end-users who only work with the data in documents that someone else has created, you can disable the SQL Spreads Design mode:
image.png

To disable the Designer, you will have to switch that license to Data Editor mode. To switch a license to Data Editor mode, please send an email to support@sqlspreads.com and we will help you to switch any of your licenses to Data Editor mode.

Password protect the Design mode

If your end-users have SQL Spreads installed with the Designer enabled, you can still protect your SQL Spreads setup by adding a Designer password that will prevent them from opening the document in Design mode.

To add a Design mode password, open the Document Settings and add a password to the Design Mode Password field:
image.png