03-03-2015 12:14 PM
27 12
tools
  1. robert peake's Avatar
    hi ive copied some excel sheets across to my 820 but i cant edit them on the phine, doesnt even give me the option...

    any tips
    02-17-2013 05:13 AM
  2. rockstarzzz's Avatar
    tap on the cell you want to edit and you will see a box on top where you can edit it. The box is on top next to fx. You will see cell content in that box. Tap inside that box, keyboard will pop up, do your editing.
    02-17-2013 05:48 AM
  3. DaveGx's Avatar
    Unfortunately, Office for WP isn't all its cracked up to be. Some docs can't be edited. Not sure if its due to certain formulas that may be in the spreadsheet or the file type its saved as. Either way, it is frustrating and embarrassing to not be able to edit the sheet at all. I am very disappointed.
    Sadly, I bet i could open up and edit the file on Android.
    02-17-2013 08:42 AM
  4. robert peake's Avatar
    thanks to all who took the time to reply when the spreadsheet opens it shows right up at the top that this document cannot be edited. i;m sur ein the past i have managed to edit the spreadsheet.

    this phone is going to make me go mad!!!!
    02-17-2013 10:02 AM
  5. simontl's Avatar
    Have you tried copying the file on pc to a skydrive folder, and then opening it on phone from there?
    02-17-2013 10:29 AM
  6. Tuner6's Avatar
    WP8 can not edit any excel sheet not created on the phone. My lap top is running Windows XP not Windows 8. Open a new, blank, excel spread sheet on the phone and copy the contents of your other spread sheet into this new, blank sheet. Then you will be able to edit the spread sheet and download it to your laptop. Unfortunately, you will only be able to use the functions available on the phone version of Excel, not all the full functions available on your laptop. I am running Office Pro 2010. This solution sucks and I am really disappointed with my windows 8 phone. This is my first smart phone so I don't know if a Droid is any better.
    02-17-2013 10:41 AM
  7. DarekK's Avatar
    I had the same problem on htc 8X. I fixed errors in formulas and now I can edit.
    02-17-2013 10:52 AM
  8. spaulagain's Avatar
    WP8 can not edit any excel sheet not created on the phone. My lap top is running Windows XP not Windows 8. Open a new, blank, excel spread sheet on the phone and copy the contents of your other spread sheet into this new, blank sheet. Then you will be able to edit the spread sheet and download it to your laptop. Unfortunately, you will only be able to use the functions available on the phone version of Excel, not all the full functions available on your laptop. I am running Office Pro 2010. This solution sucks and I am really disappointed with my windows 8 phone. This is my first smart phone so I don't know if a Droid is any better.
    Make sure the excel documents are saved as .xlsx not .xls or it will not open. I open Excel documents all the time. It would be pointless if you can only open Excel documents made from Windows Phone. No one in the right mind would use WP to create excel document all the time.

    I've been opening Excel documents on WP8 and WP7 since it was launched over 2 years ago.
    02-17-2013 11:09 AM
  9. robert peake's Avatar
    Thanks to all who tried to help, tried uplaoding to skydrive through the laptop. still no joy. they are in the xlsx format aswell.

    i tried to create a new docuemnt via the phone but as i cant edit the document i cant copy the text to paste in a new one... lol

    windows phone has sent me mental!!!
    02-17-2013 12:06 PM
  10. DaveGx's Avatar
    Thanks to all who tried to help, tried uplaoding to skydrive through the laptop. still no joy. they are in the xlsx format aswell.

    i tried to create a new docuemnt via the phone but as i cant edit the document i cant copy the text to paste in a new one... lol

    windows phone has sent me mental!!!
    I tried that too. At the very least, your think we could at least copy from it but can't even do that. I feel you, its very frustrating.
    robert peake likes this.
    02-17-2013 12:26 PM
  11. lkwaijunior's Avatar
    Hi, I don't know if I'm too late to the party, but I faced the same issue just two days ago; there's a workaround for it.

    1) first things first, Excel on wp8 will only open (and allow editing) on sheets created in MSOffice 2010 or later. I don't know why or how. So if you have the choice, always save with MSOffice 2010 or later.
    2) The workaround involves the Excel Web-app.
    2.1) Upload the sheet you need editing to skydrive
    2.2) Access the desktop version of skydrive (I used an actual desktop for that, but apparently the IE Desktop mode works too)
    2.3) From within skydrive, open the excel file via the excel web-app.
    2.3.1) The app will prompt to ask if it may convert the file into an editable version > Allow it.
    2.4) When resultant file has been converted, save it from within the excel web app (to skydrive)
    2.5) Since it's now saved, access the same file from your phone via office (load the file from skydrive; make sure you refresh the file listing so you see the new file.)
    02-17-2013 12:34 PM
  12. robert peake's Avatar
    Hi, I don't know if I'm too late to the party, but I faced the same issue just two days ago; there's a workaround for it.

    1) first things first, Excel on wp8 will only open (and allow editing) on sheets created in MSOffice 2010 or later. I don't know why or how. So if you have the choice, always save with MSOffice 2010 or later.
    2) The workaround involves the Excel Web-app.
    2.1) Upload the sheet you need editing to skydrive
    2.2) Access the desktop version of skydrive (I used an actual desktop for that, but apparently the IE Desktop mode works too)
    2.3) From within skydrive, open the excel file via the excel web-app.
    2.3.1) The app will prompt to ask if it may convert the file into an editable version > Allow it.
    2.4) When resultant file has been converted, save it from within the excel web app (to skydrive)
    2.5) Since it's now saved, access the same file from your phone via office (load the file from skydrive; make sure you refresh the file listing so you see the new file.)
    hi, thanks for trying to help, whats the excel web app, i coudlnt find it in the store.
    02-17-2013 12:47 PM
  13. stmav's Avatar
    If you go to SkyDrive in IE, and tap create, it will give you the option to create an excel file.
    robert peake likes this.
    02-17-2013 12:59 PM
  14. lkwaijunior's Avatar
    hi, thanks for trying to help, whats the excel web app, i coudlnt find it in the store.
    you have to upload the .xlsx you want edited to SkyDrive first - then you open SkyDrive on desktop mode, then just open the file from within SkyDrive. Excel webapp should pop right up.

    Remember to save the resultant file..!
    robert peake likes this.
    02-17-2013 01:10 PM
  15. robert peake's Avatar
    thanks, ok since you had posted a created a new document in skydrive and saw the excel app on the screen, next problem i cant seem to copy from the spreadsheet into this new on i have just created.... i havent got to type it all out again have i???
    02-17-2013 01:24 PM
  16. lkwaijunior's Avatar
    thanks, ok since you had posted a created a new document in skydrive and saw the excel app on the screen, next problem i cant seem to copy from the spreadsheet into this new on i have just created.... i havent got to type it all out again have i???
    I think i'll PM you.
    02-17-2013 01:29 PM
  17. robert peake's Avatar
    after many frustrating hours, i actually think i have found a way of getting a excel document on my phone which i can edit.

    In skydrive click on create a new excel sheet, give it name, rather than leave it in Excel web app, click on open in excel.

    Ive been copying and pasting the old spreadsheet into the new one.

    Then saving onto my desktop< ive found that XLSX format to be the best one and every time it works

    then back on skydrive i upload the saved spreadsheet into the skydrive and then click on the office via the phone and check it works and you can edit it...

    worked for me.... cant believe i have found a way, although i have wasted 2 days of my life
    02-17-2013 05:38 PM
  18. Tuner6's Avatar
    That sounds like what I suggested yesterday. I used that for a few days and then decided this solution sucks and abandoned it. If I want to edit my spreadsheet I use my laptop so I can do it with all the features of Excel 2010. I am really disappointed with my WP8 phone but don't know if the Driod is any better. As I said before, this is my first "smart phone" and therefore I have nothing with which to compare.
    02-18-2013 10:32 AM
  19. robert peake's Avatar
    That sounds like what I suggested yesterday. I used that for a few days and then decided this solution sucks and abandoned it. If I want to edit my spreadsheet I use my laptop so I can do it with all the features of Excel 2010. I am really disappointed with my WP8 phone but don't know if the Driod is any better. As I said before, this is my first "smart phone" and therefore I have nothing with which to compare.

    yeah it is, but i coudlnt copy from the spreadsheet in the phone as it wouldnt let me edit it so no copying the text, hence why i had to go on the pc to do it.

    at least there is a way around it, must admit i was looking at the blackberry z10 and the sony z something today, wondering whether i can stick out the windows phone, ive had blackberrys for years so this was a big switch for me, and not one thats been that enjoyable. i love the phone the layout etc but i worry its going to freeze and not sync my emails ie had to do 4/5 hard resets and it doesnt back up completely so its a big worry and i travel abroad quite a bit so if it did that when i was away i would be lost.
    02-18-2013 04:44 PM
  20. DaveGx's Avatar
    yeah it is, but i coudlnt copy from the spreadsheet in the phone as it wouldnt let me edit it so no copying the text, hence why i had to go on the pc to do it.

    at least there is a way around it, must admit i was looking at the blackberry z10 and the sony z something today, wondering whether i can stick out the windows phone, ive had blackberrys for years so this was a big switch for me, and not one thats been that enjoyable. i love the phone the layout etc but i worry its going to freeze and not sync my emails ie had to do 4/5 hard resets and it doesnt back up completely so its a big worry and i travel abroad quite a bit so if it did that when i was away i would be lost.
    While I too am not the most pleased with WP yet, if you are having hardware issues, having to reset, etc....i would definitely get your phone replaced. Your phone sounds defective
    02-18-2013 05:38 PM
  21. MikeSo's Avatar
    MS is working on a fix. The issue is not your phone, it's the Excel Web App. Until it's fixed, you can't edit a spreadsheet on the phone if you've opened it in Skydrive on the web. See this thread for details: http://forums.windowscentral.com/win...cel-phone.html

    Important part: "we're working on getting the fix shipped as soon as we can. But at this point the date is still not certain. I can say it will be out no later than end of Feb, and earlier if we can. I hope to get it earlier than that."

    Check the thread linked to in that post (on MSs forum) for updates.
    02-19-2013 01:50 AM
  22. spaulagain's Avatar
    WP8 can not edit any excel sheet not created on the phone. My lap top is running Windows XP not Windows 8. Open a new, blank, excel spread sheet on the phone and copy the contents of your other spread sheet into this new, blank sheet. Then you will be able to edit the spread sheet and download it to your laptop. Unfortunately, you will only be able to use the functions available on the phone version of Excel, not all the full functions available on your laptop. I am running Office Pro 2010. This solution sucks and I am really disappointed with my windows 8 phone. This is my first smart phone so I don't know if a Droid is any better.
    Spreading lies like this is stupid. WP can open Excel documents from other sources all day long. They have to be the up to date .xlsx file types, but if you're not using .xlsx instead of .xls, you need to get with the times. .xls has been outdated for years.
    02-19-2013 06:18 PM
  23. DaveGx's Avatar
    Spreading lies like this is stupid. WP can open Excel documents from other sources all day long. They have to be the up to date .xlsx file types, but if you're not using .xlsx instead of .xls, you need to get with the times. .xls has been outdated for years.
    Many still use the format. This is on MS , no one else. Office for WP should allow you to open and edit these files. You shouldn't have to jump through hoops to do so. I get emailed a spreadsheet that I need to fill in or edit, but I can't always do that and that's bs. MS dropped the ball here.
    02-19-2013 07:36 PM
  24. RichHowerton's Avatar
    i created an xlsx file using office excel 2010 on my laptop, uploaded to skydrive. then opened on windows phone, and had no trouble editing, making changes, and saving to skydrive. then open back up on laptop using office excel 2010, and changes made on pphone were there. I do not see any issues.
    02-19-2013 08:50 PM
  25. realwarder's Avatar
    If you use Office 2013 the integration is even sweeter. Just open and save to SkyDrive simply on the PC and edit if required on the phone.

    Everyone should be on XLSX format these days as it's more consistent than the older versions and is also an open standard which means other office apps are more likely to open it and have it look the same.
    02-19-2013 09:35 PM
27 12

Similar Threads

  1. Cant send mms messages on my htc radar 4 g
    By Sandrot in forum HTC Radar
    Replies: 0
    Last Post: 02-02-2013, 04:10 PM
  2. Can't edit my Excel files on WP7 Mobile Office
    By rsshirlevel in forum Windows Phone Apps
    Replies: 0
    Last Post: 01-30-2013, 03:29 AM
  3. Replies: 3
    Last Post: 01-17-2013, 05:23 PM
  4. Calling Back the Dogs on My Nokia 920/820 Rants.
    By andrelamont in forum Upcoming & Rumored Windows Phones
    Replies: 35
    Last Post: 09-11-2012, 12:58 PM
  5. Replies: 0
    Last Post: 09-10-2012, 06:21 AM
LINK TO POST COPIED TO CLIPBOARD