Help with exporting an excel spreadsheet to sharepoint

Hi Sarah,

I understand that you want to retain the formula in excel table and keep data synced with SharePoint list.

As the formula will be retained after using the 'Synchronising with sharepoint lists' add-in, I recommend to sync the excel with SQL server.

Then create an external list in SharePoint with SQL table which is synced with the excel table.

More references:

How-To Synchronize Data Between Excel and SQL Server | Linked Server: http://ift.tt/1uKyylm

How to: Create External Lists in SharePoint: http://ift.tt/1o4W79m

Best regards.

Thanks

---

Victoria Xia

TechNet Community Support