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.

This still does not work for me. I have gone to skydrive.com opened the workbook in web app and edited then closed out. When I go to it on my phone it still says "workbook cannot be edited" What now?

I have been struggling with this issue for weeks and was very excited to find this post. However, even after this posted fix, I could not get around the issue. I recreated the workbook from scratch checking after every change to find the issue. Everything worked great until I got to a cell with this formula in it '=if(a2<>"",datediff(a2,a3,"d"),"")' Seems that not only is datediff deprecated in excel, it simply will not let you edit a file on wp8 if the workbook contains it. Once I replaced the function, I could edit the file on my phone. Check for deprecated function if you are having this issue. Brian Hoyt

Hi - A number of you have reported that even after the fix for this issue was shipped you are still having issues editing your docs on your phone. First off, sorry you're having issues. I know this is not the experience you would like to have. However, given the testing we did before shipping this fix, and the positive response we've seen from other customers, we are confident the original issue is indeed fixed now. If you are having problems still it is very likely an issue that is (unfortunately) By Design, meaning you are hitting an inherent limitation of the product. It is something other than the topic of this forum thread. Not all excel files are editable on the phone. There are a number of features, if present in the workbook, which will prevent that workbook from being edited on the phone. This fact existed before this particular issue was introduced (and then fixed). I do not have a good list of such features to refer you to unfortunately. I will try and assemble one and pass it along. I know this is less than ideal but its the best I can do. In the meantime you may examine any workbook that is not editable on the phone and experiment by removing features one at a time and retrying. In this way you may discover the feature that is blocking you from editing. I would consider looking at features like shapes, images, charts, pivot tables, comments, etc. Thanks for your feedback and for using Excel Web App. Rob

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-03-14T22:20:30+00:00

This still does not work for me. I have gone to skydrive.com opened the workbook in web app and edited then closed out. When I go to it on my phone it still says "workbook cannot be edited"

What now?
Was this answer helpful?

0 comments No comments
Anonymous

2013-03-07T01:21:37+00:00

A few days ago I indicated I would try and find some info to help folks understand which specific Excel features may make your workbooks not editable on the phone. I wanted to provide that info now.

To know what features may cause your workbook to not be editable in Excel for Windows Phone, please refer to this support article: http://www.windowsphone.com/en-US/how-to/wp8/office/microsoft-office-mobile-faq. 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. In addition, remember that we only support editing of spreadsheets that are in xlsx file format.

I know a number of you have expressed frustration about this issue and I hope this info helps you to know how to deal with it or at least understand it. ~Rob
Was this answer helpful?

0 comments No comments
Anonymous

2013-03-03T17:45:53+00:00

I have been struggling with this issue for weeks and was very excited to find this post. However, even after this posted fix, I could not get around the issue. I recreated the workbook from scratch checking after every change to find the issue.

Everything worked great until I got to a cell with this formula in it '=if(a2<>"",datediff(a2,a3,"d"),"")'

Seems that not only is datediff deprecated in excel, it simply will not let you edit a file on wp8 if the workbook contains it. Once I replaced the function, I could edit the file on my phone.

Check for deprecated function if you are having this issue.

Brian Hoyt
Was this answer helpful?

0 comments No comments
Anonymous

2013-03-01T23:59:23+00:00

Hi - A number of you have reported that even after the fix for this issue was shipped you are still having issues editing your docs on your phone.   First off, sorry you're having issues. I know this is not the experience you would like to have. However, given the testing we did before shipping this fix, and the positive response we've seen from other customers, we are confident the original issue is indeed fixed now. If you are having problems still it is very likely an issue that is (unfortunately) By Design, meaning you are hitting an inherent limitation of the product. It is something other than the topic of this forum thread.

Not all excel files are editable on the phone.   There are a number of features, if present in the workbook, which will prevent that workbook from being edited on the phone. This fact existed before this particular issue was introduced (and then fixed). I do not have a good list of such features to refer you to unfortunately. I will try and assemble one and pass it along. I know this is less than ideal but its the best I can do.

In the meantime you may examine any workbook that is not editable on the phone and experiment by removing features one at a time and retrying. In this way you may discover the feature that is blocking you from editing.  I would consider looking at features like shapes, images, charts, pivot tables, comments, etc.

Thanks for your feedback and for using Excel Web App.

Rob
Was this answer helpful?

0 comments No comments