Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have been displaying an Excel Workbook as a webpart in SharePoint Online. The users are allowed to edit the excel file. I am trying to save the changes done by the user.

Is there any other way to save the changes in workbook other than this?

I have posted this question over in stackoverflow as well.

share|improve this question
add comment

2 Answers 2

Editing an Excel document similar to Skydrive and displaying the results in an Excel Services Web Part is possible with an O365 E3 or E4 plan (it is not possible with only a SharePoint online subscription).

In order to edit an Excel document in the browser you need to have Office Web Apps (edit ability, not just the read only ability included in E1) which is only included in the Office 365 P1, E2, E3 and E4 plans. If you only own SharePoint online (and not the entire suite) Office Web Apps are not included with the license and it must be purchased separately.

share|improve this answer
    
Thanks for the response. I think we have E3 and I am able to edit the excel in the web part. But I am looking for solution to save the changes done in the webpart other than using ECMA script. –  Kiru May 8 '12 at 21:10
add comment

As I understand it the changes are automatically saved in SharePoint Online. Or are you referring to they add a value to the Excel Services Web Part and that isnt saved. The web parts are more for analysis and reporting and not for actuall modification like if you were to edit the document through the browser.

share|improve this answer
    
I am trying to have Excel to allowed to edit similar to Skydrive in the browser and generate reports after modification. Do you think I am taking wrong approach? –  Kiru May 8 '12 at 15:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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