1. SGoyal's Avatar
    I downloaded a xlsx file from my gmail to my Lumia 520. But when i open it, on the green strip at the top it shows Can't edit.
    I also tried uploading it to skydrive and then opened it from there. Still couldn't edit. Please help
    02-28-2014 10:39 AM
  2. dznk's Avatar
    It appears there could be a number of reasons why you may not be able to edit it on your phone. According to Microsoft, an Excel file will stay in Read Only mode on your phone if it has any of the following:

    • Functions that aren't supported on the phone. For info about which Excel functions are supported, see the Microsoft Support article about supported content in Excel Mobile.
    • Data validation in one or more cells.
    • Array formulas.
    • Data tables.
    • Slicers.
    • Macros enabled.
    • Large column or row widths.
    • Formulas that contain links or references to other workbooks.
    • Formulas with structured references.
    • Formulas that contain references, content, or formatting beyond cell IV16384.
    • Formulas that are longer than 512 characters or have more than 30 arguments in them.
    • Tracked changes.
    • Dialog sheets.
    • XML markup that isn't formed correctly.
    • OLE objects or ActiveX controls.
    03-02-2014 11:24 AM
  3. anon(5650876)'s Avatar
    This is sick. MSFT sucks.
    05-26-2014 07:44 AM
  4. RudraPratap Singh's Avatar
    Dear, I read somewhere that to edit an excel document in windows phone you must have Windows Live ID. So try that. If this don't apply then there might be any other problem..
    05-26-2014 08:27 AM
  5. mayur007's Avatar
    This happens because of the macros which u had use in excel file bcoz of that it shows can't edit workbook........no solution for that bcoz microsoft doesn't provide support for it same like for password protection file also......so i think they should work on both this think
    05-27-2014 09:15 AM
  6. Viswanathan Ramasamy's Avatar
    I was editing the same document in Windows 8 without any issues. Upgraded to 8.1 and now it says can't edit workbook. I opened it from OneDrive, still same. I'm using windows mobile only for office installed in it. Now I don't have any reasons for using this mobile anymore unless and until they fix this mighty horrible bug soon.
    ramji ICWA likes this.
    07-13-2014 02:19 AM
  7. Justin Nitsuj's Avatar
    Open new spreadsheet on phone and save to Onedrive. Then open on PC and copy data. Pain in the a.. but it worked for me. Stupid pretend business phone
    09-17-2014 01:53 AM
  8. Loco5150's Avatar
    Excel on Windows Phone is probably one of the biggest jokes in mobile history.

    Can you even copy/paste multiple cells?

    People working with it at Microsoft are probably on crack or something. It's insane that in the obvious functions like here, where they could easily outshine iOS and Android by making the WP experience amazing, they make something that makes me want to change platform.

    They are bunch of idiots if you ask me.
    09-17-2014 01:59 AM
  9. cojomo's Avatar
    If you could edit an Excel document before the 8.1 upgrade but can't now, open the doc in a PC and save it as an excel, not an excel 03 or 07 or whatever. I did this and it unlocked the document and I can now edit it on my phone.
    09-18-2014 04:30 AM
  10. AV2RY's Avatar
    I downloaded a xlsx file from my gmail..... it shows Can't edit.
    It's probably in Protection Mode and (I assume) it can't be unlocked on phone. Download same file on PC, open, unlock it (it will show on top if its protected), Save to OneDrive. Open it on your phone from OneDrive, now you should be able to edit
    09-18-2014 05:00 AM
  11. Sanlopez's Avatar
    Microsoft claims you can work on office documents. If you look at the large number of restrictions this has, then their claim is basically a BLATANT LIE. I recommend you throw away this phone if you need to work on your work or office stuff.
    12-15-2014 02:24 PM
  12. aximtreo's Avatar
    I'm going to take a different approach. I think you have lived in darkness too long. It's time you saw the light. I would highly suggest you buy a used WP phone, something in the mid range of price and capability. The exact model will be determined by your carrier supports.

    It's been stated that all LUMIA phones will be able to upgrade to Win 10. Using this phone with WP 8 or whatever it has on it will allow you to get familiar with WP's and the OS. If you like WP at the level it is now, you will only like it more on WP 10. If you don't like it now, sell the phone and go about your business. You will have learned something new which is always good and the expenditure won't break the bank.

    Your decision but I offer this for your consideration.

    By the way, this site is the absolute best source of help and information on WP phones. We have sister sites that offer good support on Android and IOS phones as well.
    12-15-2014 05:38 PM
  13. yaron zeevik's Avatar
    The office app is very limited coz it's inside the OS.. They can't update it because then they'll need to update the whole OS..the light in the end of the tunnel is that in win10 they'll be able to update it way more often and probably it will be better then Ios and Android
    12-15-2014 05:50 PM
  14. uteweatherman's Avatar
    The items on this list applies to all my excel worksheets. Hopefully this will be fixed with W10
    12-31-2014 09:49 AM
  15. mark dal1's Avatar
    I downloaded a xlsx file from my gmail to my Lumia 520. But when i open it, on the green strip at the top it shows Can't edit.
    I also tried uploading it to skydrive and then opened it from there. Still couldn't edit. Please help
    -sign out and sign in...works on my lumia 550.
    03-08-2016 09:28 PM

Similar Threads

  1. So when can we port Wp8.1 on our android devices
    By hamzie11 in forum Windows Phone 8.1
    Replies: 18
    Last Post: 04-30-2015, 02:39 PM
  2. Replies: 7
    Last Post: 03-01-2014, 12:57 AM
  3. Sometimes can't click on tiles
    By shikerman in forum Nokia Lumia 925
    Replies: 2
    Last Post: 02-28-2014, 06:34 AM
  4. Can't sync gmail contacts...
    By reidbp in forum Nokia Lumia Icon
    Replies: 1
    Last Post: 02-27-2014, 06:36 PM
  5. Nokia Trailers can't play trailers on my Lumia 1520
    By dfeghali in forum Nokia Lumia 1520
    Replies: 0
    Last Post: 02-27-2014, 01:10 PM