Robert Thomas
asked on
Configure Sharepoint 2013 to allow Excel files to be edited online
Good Afternoon:
I've developed a SharePoint 2013 site with a documents library for excel files. The files can be viewed online on all browsers (firefox, chrome & IE) how ever I can never edit them. The files show the following message in the browser
Followed by:
We can't show these features in the browser:
• SharePoint lists
But you can see all the content in this workbook by opening the file in Excel.
I have gone through SharePoint central administration to make sure the excel services were active & that the list settings were set to allow to be opened in browser. So far I have not been able to find what Im missing to be able to allow the site to allow the excel files to be edited online.
I've developed a SharePoint 2013 site with a documents library for excel files. The files can be viewed online on all browsers (firefox, chrome & IE) how ever I can never edit them. The files show the following message in the browser
- Unsupported Features : There are some features in your workbook that we can't show in the browser
Followed by:
We can't show these features in the browser:
• SharePoint lists
But you can see all the content in this workbook by opening the file in Excel.
I have gone through SharePoint central administration to make sure the excel services were active & that the list settings were set to allow to be opened in browser. So far I have not been able to find what Im missing to be able to allow the site to allow the excel files to be edited online.
Macros and some other Excel extras and features won't work in the browser.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. I tried to extension to see if it could find any errors. Unfortunately there wasn't error found. I also check to see if there was any XML mapping in the files and there wasn't. The files themselves seem to be fine. I'm beginning to think its a setting hidden somewhere in our SharePoint setting. Any thoughts?
As a troubleshooting step, try a few "clean" excel files to see what happens. Going down the road of searching and changing hidden settings, especially using some well intended advice from Google can lead to a bad situation often.
Best of luck...
Best of luck...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Excel services (a enterprise license feature), offer full read and write capability. The limitations are as I listed above.
ASKER
I went through our SharePoint Sever and I know that our excel service is on, however I did not realize that Web Apps was/needs to be on a totally different server. With my current permissions I only have access to one specific boxes (the one hosting SharePoint) am waiting for our network admin to return to see if any of our boxes have Web Apps setup. From what I've read so far I am confident that this is the problem and we are probably going to have set up a virtual sever and configure it to work with out SharePoint 2013 site. Thanks.
Walter: Per Microsoft, Excel Calculation Services workbooks cannot be edited in the browser. You can download, edit, and save back to a library.
Per Microsoft:
"...you cannot use Excel Services to create new workbooks or to edit existing workbooks. To author a workbook for use with Excel Services, you can use Microsoft Excel 2013."
More here: https://msdn.microsoft.com/en-us/library/office/ms546696.aspx
So in SP 2013, you have to use MS Excel to create/edit workbooks.
Note that in SP 2016, Excel Calculation Services has been removed from SharePoint; you now MUST use Excel Web App for all in-browser viewing/editing.
More here: https://blogs.office.com/2016/11/21/updates-for-excel-services-and-bi-in-sharepoint-2016-on-premises/
Per Microsoft:
"...you cannot use Excel Services to create new workbooks or to edit existing workbooks. To author a workbook for use with Excel Services, you can use Microsoft Excel 2013."
More here: https://msdn.microsoft.com/en-us/library/office/ms546696.aspx
So in SP 2013, you have to use MS Excel to create/edit workbooks.
Note that in SP 2016, Excel Calculation Services has been removed from SharePoint; you now MUST use Excel Web App for all in-browser viewing/editing.
More here: https://blogs.office.com/2016/11/21/updates-for-excel-services-and-bi-in-sharepoint-2016-on-premises/
Great information, many thanks...