I have discovered that if I open/edit a file with the SkyDrive Web App with a PC, the next time I open that file on my WP8 HTC 8x or my wifes Lumia 822, I will receive the message "Can't Edit Workbook". However if I open the file with the PC desktop then save it to SkyDrive, I will then be able to edit the file with WP8. Bottom line is, if I edit the document with Excel Web App it will become un-editable with the WP 8. The result is the same with my HTC 8x and my Lumia 822. Here's a link to one of the files on my SkyDrive.... https://skydrive.live.com/redir?resid=2041DB813A877186!847&authkey=!AJIZRXBAC8lnIcw C'mon microsoft, you're supposed to be the big boy on the block when it comes to spread sheets. Unacceptable that simple excel workbooks can not be edited with WP8 after being edited with the online Web App. Google doc's doesn't have this problem with my old Android.

Since this morning I also have this problem. And no workaround works: Editing it in Excel 2010 or the excel web app: When I open it on my Phone (Lumia 920), it still says: Can't edit workbook. Do I have to start a new issue?

But how do you explain the following issue: I open the sheet in Excel, select and copy all (CTRL-A) to a new workbook. Upload this one to SkyDrive, and now it's editable! So there is nothing in my Workbook with formula's, makeup or what so ever that will block the phone to edit it. Somehow the web interface of SkyDrive must make changes to the Workbook that will stop the Windows Phone to be able to edit it!

Sadly exactly the same problem with excel spread sheets in SharePoint 2013 except it was working last week. The only workaround I can find is to make a second link to the file in the SharePoint library and click on that. Then it loads.

Excel Web App causes .xlsx files to become un-editable on Windows Phone 8

Anonymous

I have discovered that if I open/edit a file with the SkyDrive Web App with a PC, the next time I open that file on my WP8 HTC 8x or my wifes Lumia 822, I will receive the message "Can't Edit Workbook". However if I open the file with the PC desktop then save it to SkyDrive, I will then be able to edit the file with WP8.

Bottom line is, if I edit the document with Excel Web App it will become un-editable with the WP 8. The result is the same with my HTC 8x and my Lumia 822.

Here's a link to one of the files on my SkyDrive....

https://skydrive.live.com/redir?resid=2041DB813A877186!847&authkey=!AJIZRXBAC8lnIcw

C'mon microsoft, you're supposed to be the big boy on the block when it comes to spread sheets. Unacceptable that simple excel workbooks can not be edited with WP8 after being edited with the online Web App. Google doc's doesn't have this problem with my old Android.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Hi all –

So there continues to be some confusion on this issue and I want to try and resolve it in one comprehensive response that hopefully covers all sides of this and addresses all your questions. This response will be marked as the new Answerto this thread and the thread will then be locked. We are happy to address any questions or issues you have but these new questions or comments are best addressed in new issue threads you can create at answers.microsoft.com. Once again we apologize for any inconvenience this particular issue may have caused you.

To summarize..the issue is that some of you have been unable to edit workbooks on your phone in Excel for Windows phone after a ‘save’ of the file in Skydrive or Office Web Apps server. The 'bug' was introduced in Skydrive on Jan 24 and in Sharepoint/ Office Web Apps server as part of the March Public Update.

**If you experience the issue with files in Skydrive:**This issue has been fixed for Skydrive. Any ‘new’ Excel files created in Excel Web App as of today (or later than February 19, 2013 when we shipped the fix for this) can now be successfully edited in Excel for Windows Phone. For files that were created or last saved before February 19, you will first need to open those files in Excel Web App (or Excel desktop client), make a change to the file (edit a single cell for instance) and then save the file back to Skydrive for the file to be editable again on the phone. Excel Web App has ‘autosave’ so simply closing the file is sufficient after making the change.

**If you experience the issue with files in Sharepoint 2013/Office Web Apps 2013 (on premise deployments)**If you are experiencing the issue described in this thread and it is related to your own (on premise) deployment of Sharepoint and Office Web Apps Server, you can address it by installing a couple updates from the April Public Update. The specific updates you would need are:

· Security Update for Microsoft SharePoint Enterprise Server 2013 (KB2737969) 64-Bit Edition

· Update for Microsoft Office Web Apps Server 2013 (KB2810007)

Please remember that as in the case of Skydrive, you will need to do a 'Save' on the affected file using Excel Web App or Excel desktop client to allow the file to be editable on Excel for mobile phone.

**If you still cannot edit workbooks on your phone after following above steps:**If you are still having problems editing workbooks on your phone after following these above steps, it is an issue that is (unfortunately) By Design, meaning you are hitting an inherent limitation of the product. There are some features (‘unsupported features’) that can block an Excel file from being viewed or edited in Excel Web App, and in Excel for Mobile. These are inherent limitations of these products. We are working to remove many of these blocking issues..it’s a priority for our teams. But it’s important to understand that these limitations do exist currently. You won’t unfortunately be able to view or edit 100% of all features in the web app or phone.

· For help understanding issues with unsupported features in Excel for Mobile phone:

To know what features may cause your workbook to not be editable in Excel for Windows Phone, please refer to this support article. Look for the link there that says “Why can’t I edit some Microsoft Office documents on my phone.” The info there helps identify what features are not supported in the phone and which may cause you to see the “Can’t Edit Workbook” message at the top of the view when viewing on the phone.

· For help understandingissues with unsupported features in Excel Web App:

To understand the story around unsupported features that may block viewing or editing in the Excel Web App, please refer to this support article. Some features such as Sheet Protection can block the file from being opened at all in the browser. Some features only block editing of the file in the browser.

Once you understand what features are blocking, you can then consider whether it is an option for you to remove these features from your workbook.

Thank you for your feedback and patience while we work through this issue. And thanks for using Excel Web App!

-Rob

0 comments

54 additional answers

Anonymous

2013-04-19T09:23:25+00:00

Since this morning I also have this problem. And no workaround works: Editing it in Excel 2010 or the excel web app: When I open it on my Phone (Lumia 920), it still says: Can't edit workbook.

Do I have to start a new issue?
Was this answer helpful?

0 comments No comments
Anonymous

2013-04-19T16:15:29+00:00

Hi Ron and Mark -

Sorry you're having issues here. I am going to recycle some info that is provided earlier in this thread.

Background: There are some features (‘unsupported features’) that can block an Excel file from being viewed or edited in Excel Web App, and in Excel for Mobile. These are inherent limitations of these products. We are working to remove as many of these blocking issues as we can. It’s a priority for our teams, but its important to understand that these limitations do exist currently. You won’t unfortunately be able to view or edit 100% of all features in the web app or phone.

For issues with unsupported features in Excel for Mobile phone:

To know what features may cause your workbook to not be editable in Excel for Windows Phone, please refer to this support article. Look for the link there that says “Why can’t I edit some Microsoft Office documents on my phone.” The info there helps identify what features are not supported in the phone and which may cause you to see the “Can’t Edit Workbook” message at the top of the view when viewing on the phone.

For issues with unsupported features in Excel Web App:

To understand the story around unsupported features that may block viewing or editing in the browser, please refer to this support article. Some features such as Sheet Protection can block the file from being opened at all in the browser. Some features only block editing of the file in the browser.

Once you understand what features are blocking you, you can then consider whether it is an option for you to remove these features from your workbook.

I hope this helps and sorry you’re having difficulty. I hear your frustration. We are working on eliminating as many of these sorts of issues as we can but it will take some time.

Rob
Was this answer helpful?

0 comments No comments
Anonymous

2013-04-22T09:19:35+00:00

But how do you explain the following issue: I open the sheet in Excel, select and copy all (CTRL-A) to a new workbook. Upload this one to SkyDrive, and now it's editable!

So there is nothing in my Workbook with formula's, makeup or what so ever that will block the phone to edit it. Somehow the web interface of SkyDrive must make changes to the Workbook that will stop the Windows Phone to be able to edit it!
Was this answer helpful?

0 comments No comments
Anonymous

2013-04-29T17:57:10+00:00

Sadly exactly the same problem with excel spread sheets in SharePoint 2013 except it was working last week. The only workaround I can find is to make a second link to the file in the SharePoint library and click on that. Then it loads.
Was this answer helpful?

0 comments No comments