0

I am using SharePoint 2013 and Microsoft Office 2007 or above.

Scenario:

  1. I upload a Excel file to a SharePoint 2013 list.
  2. Now, I want to import this Excel file from this SharePoint list back to Excel.
  3. And link this imported Excel file with SharePoint.

And I don't want the SharePoint list to be imported in the Excel file, it is the Excel contents.

How can I do this?

Is this possible with all the MS office versions (2007, 2010 & 2013)?

Thank You

1

Using Excel 2003 version, you can synchronize SharePoint list and the excel, in Office Excel 2007 and later on versions, you can no longer update a SharePoint list with changes that you make to the table data in Excel after that data has been exported.

For your scenario, you can make use of the OOTB "Export to Excel" option in the SharePoint, it will create a new Excel Worksheet with the data in the SharePoint list and it has a link to the SharePoint list from which you have exported, When you refresh the table data in Excel, the latest data from the SharePoint site overwrites the table data on the worksheet, including any changes that you made to the table data.

Reference:

  1. How to Export Excel Sheet to SharePoint List
0

According to a post on Technet, an Excel add-in still works to synchronize lists and Excel tables in SharePoint 2010. I have not tried or tested it with SharePoint 2013, but it may be worth a go.

The tool: http://www.microsoft.com/en-us/download/details.aspx?id=9345

The documentation: http://msdn.microsoft.com/en-us/library/office/bb462636(v=office.11).aspx

The essence of a list has not changed much from SharePoint 2007 to SharePoint 2013, so chances are that this will still work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.