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

Anonymous
2013-01-30T15:01:33+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

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
2013-05-07T15:54:54+00:00

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

Was this answer helpful?

0 comments

54 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2013-03-01T23:38:32+00:00

    I have the same issue with Nokia Limua 920

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-02-28T18:07:49+00:00

    This fix is not working for me, at least with an existing Excel file that was previously broken. Today i have opened the file in Excel Web App, made a change to a single cell, let it save. Then on my phone I have deleted the downloaded copy just to rule out any caching issues, and opened the file again from my skydrive - still get 'Can't Edit Workbook'.

    Phone is HTC 8x,

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-02-24T01:15:50+00:00

    Today I noticed that one of the excel spreadsheet I was unable to edit before is editable now. However, there is still another excel spreadsheet that have the can't edit issue. Hope that they will all be fixed soon. At least the one that I am using daily is editable at this point :D

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-02-22T20:34:48+00:00

    Hi Curtis - That's a great idea but I don't believe we have a tool for that.  For unsupported features in the Excel web app this link may be helpful. It includes a list of features that have varying levels of support:

    http://msdn.microsoft.com/en-us/library/ms496823(v=office.12).aspx.

    I'm not aware of such a list for Excel mobile but if I can find one I'll add it here.  

    Thanks for the feedback. 

    Rob

    Was this answer helpful?

    0 comments