help

Looking for something specific? Begin with 'Getting started' and then read the documentation for information on how to use RowShare.

Excel® and Access®

You can open and edit your RowShare tables directly in Excel and Access. The access rights you set on a table in RowShare also apply to Excel and Access, determining what you can see and edit.

Excel, export and synchronization

From any table, click on Excel in the action bar to export your RowShare table or even synchronize it with Excel.

The available options include:

·         Excel Sync (Read and Write): Choose this option to edit your RowShare table directly in Excel and sync updates with RowShare.. You will be allowed to see and modify rows and columns according to your RowShare permissions.

·         Export : this standard export option creates a file with the same rows and columns you are allowed to see in RowShare. Supported formats are: Excel (.xlsx), Excel 97-2003 (.xls) and text (.csv).

Editing a table in Microsoft Excel

If you would like to edit your RowShare table from Excel, choose the second option. Simply open the downloaded Excel file to begin synchronizing with RowShare.

https://www.rowshare.com/Images/Pages/Features/excel-sync/excelsync_2.jpg

Note: Don’t forget to click “Enable Editing” in the warning bar. This security warning appears in Excel on all downloaded documents.

You can edit data from Microsoft Excel even without an internet connection, although you will of course need to be back online to publish your changes to RowShare. To sync changes in RowShare and get the latest version of the table, right click on the Excel table and select Table > Synchronize with SharePoint from the menu.

https://www.rowshare.com/Images/Pages/Features/excel-sync/excelsync_3.jpg

With two-way file synchronization, your RowShare table will be kept updated with any changes made in Excel, simply refresh the RowShare page to view changes made in Excel. If there are any conflicts, such as the same row having been edited in both RowShare and Excel, Excel will prompt the user to choose which version to keep.

Only Excel running on Windows supports this feature.

Editing a table in Microsoft Access

RowShare also provides a synchronization feature for Microsoft Access. Open the SharePoint List menu in the Import & Links group of the External Data tab in Microsoft Access.

On the following screen, simply insert the address https://www.rowshare.com as a SharePoint site:

Microsoft Access will then ask you to log in to your RowShare account to access all your tables.

Once logged in, you will be able to modify your tables with Microsoft Access. Synchronization is then guaranteed: any changes will be automatically sent to RowShare.

Only Access 2013 or higher will support the dual-way synchronization feature.

Lists of options

Microsoft Excel does not support multiple values drop down lists, so if your RowShare column allows to select multiple values, you will need to use a combination of special characters ;# (semicolon followed by the number sign) to separate the different values.

Your list will appear as follows in Excel:

Special columns

Each RowShare table synchronized with Microsoft Excel or Access has two additional columns: Id and Index. These are non-editable technical columns to identify rows during the synchronization process.

You can hide them in Excel or Access, but you can’t delete them. The synchronization process would no longer work if these two columns were deleted.

Also, despite the menu labels in Excel and Access, synchronization is not done using Microsoft SharePoint® technology.

Need more information?

Didn't find the answer? Ask questions to our support team!