0

We have an Excel document which contains in 2 columns information about a product (column A) and its delivery time (column B). In column C, there are also internal comments about the reasons for this delivery time.

The Excel-document is stored on a normal Windows file server. It is updated daily and those changes shall be reflected also immediately on SharePoint:

We want to publish the information from columns A and B (and NOT the info from Column C) on a SharePoint 2013 server (Standard), maybe in another Excel document, but it could also be in a list or on a webpage.

Which ways are there to make that possible?

2

You can configure excel services, to display excel file from SharePoint site or network shared path or from web folder address.

Refer this link to configure excel services: How to Configure Excel Services in SharePoint 2013

Now to show only column A and B from that excel, you will need to Defined Name items in workbook.

A named item can be a chart, table, a PivotChart report, a PivotTable report, a slicer, a Timeline control, a worksheet, or even a range of data in a worksheet.

Reference for Named Item: Share workbooks by using Excel Services

1

There are several options.

Hide column C in the workbook and protect the sheet, so the hidden column cannot be unhidden by the regular user.

Or don't use an Excel spreadsheet in the first place. Use a SharePoint list instead and create the default view with only column A and B. Use permissions to determine who can see a view with column C for updating the list.

  • thank you very muc h! I did not know that I can use permissions for views. Is this possible in SharePoint 2013 Standard? But can I then be sure that a user does not create his own view which shows the "secret" column C? – mBBe May 28 '18 at 10:23
  • 1
    You can't- at least not directly in a list view. But you can set up a Page with a list view Web part that shows columns A, B and C. Then you can restrict who can access that page with permissions. And you can use list permissions to ensure that users cannot build their own views. – teylyn May 28 '18 at 10:28
  • thanks a lot! This looks like our solution, as the Excel Services need SharePoint Enterprise, which we do not have. – mBBe May 28 '18 at 10:32
  • is there a way to update the Sharepoint List automatically from the original Excel file, each time the file is saved? – mBBe May 28 '18 at 10:34
  • 1
    No. You keep the data in SharePoint, you edit the data in SharePoint. You can read SharePoint data into Excel, but you cannot write Excel data into Sharepoint. Sorry. Don't shoot the messenger. – teylyn May 28 '18 at 10:43

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.