Welcome to the WPCentral Forums Create Your Account or Ask a Question Answers in 5 minutes - no registration required!
Page 1 of 2 12 LastLast
Results 1 to 25 of 26
Like Tree1Likes
  1. robert peake's Avatar
    Member

    Posts
    43 Posts
    Global Posts
    46 Global Posts
       #1  
    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
  2. #2  
    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.
    Patient Windows Phone User since October 2010 till cores and apps do us apart.

    Read the rules before you post. If you post, we will assume you've read this already.
  3. DaveGx's Avatar
    Member

    Posts
    555 Posts
    #3  
    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.
  4. robert peake's Avatar
    Member

    Posts
    43 Posts
    Global Posts
    46 Global Posts
       #4  
    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!!!!
  5. simontl's Avatar
    Member

    Posts
    12 Posts
    #5  
    Have you tried copying the file on pc to a skydrive folder, and then opening it on phone from there?
  6. Tuner6's Avatar
    Member

    Posts
    2 Posts
    #6  
    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.
  7. DarekK's Avatar
    Member

    Posts
    1 Posts
    #7  
    I had the same problem on htc 8X. I fixed errors in formulas and now I can edit.
  8. spaulagain's Avatar
    Member

    Posts
    980 Posts
    #8  
    Quote Originally Posted by Tuner6 View Post
    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.
  9. robert peake's Avatar
    Member

    Posts
    43 Posts
    Global Posts
    46 Global Posts
       #9  
    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!!!
  10. DaveGx's Avatar
    Member

    Posts
    555 Posts
    #10  
    Quote Originally Posted by robert peake View Post
    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.
    Thanked by:
    robert peake likes this.
  11. lkwaijunior's Avatar
    Member

    Posts
    17 Posts
    #11  
    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.)
  12. robert peake's Avatar
    Member

    Posts
    43 Posts
    Global Posts
    46 Global Posts
       #12  
    Quote Originally Posted by lkwaijunior View Post
    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.
  13. stmav's Avatar
    Retired Moderator

    Posts
    3,685 Posts
    Global Posts
    3,767 Global Posts
    #13  
    If you go to SkyDrive in IE, and tap create, it will give you the option to create an excel file.
    Thanked by:
  14. lkwaijunior's Avatar
    Member

    Posts
    17 Posts
    #14  
    Quote Originally Posted by robert peake View Post
    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..!
    Thanked by:
  15. robert peake's Avatar
    Member

    Posts
    43 Posts
    Global Posts
    46 Global Posts
       #15  
    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???
  16. lkwaijunior's Avatar
    Member

    Posts
    17 Posts
    #16  
    Quote Originally Posted by robert peake View Post
    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.
  17. robert peake's Avatar
    Member

    Posts
    43 Posts
    Global Posts
    46 Global Posts
       #17  
    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
  18. Tuner6's Avatar
    Member

    Posts
    2 Posts
    #18  
    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.
  19. robert peake's Avatar
    Member

    Posts
    43 Posts
    Global Posts
    46 Global Posts
       #19  
    Quote Originally Posted by Tuner6 View Post
    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.
  20. DaveGx's Avatar
    Member

    Posts
    555 Posts
    #20  
    Quote Originally Posted by robert peake View Post
    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
  21. MikeSo's Avatar
    Member

    Posts
    654 Posts
    #21  
    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: MS excel phone

    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.
  22. spaulagain's Avatar
    Member

    Posts
    980 Posts
    #22  
    Quote Originally Posted by Tuner6 View Post
    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.
  23. DaveGx's Avatar
    Member

    Posts
    555 Posts
    #23  
    Quote Originally Posted by spaulagain View Post
    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.
  24. RichHowerton's Avatar
    Member

    Posts
    93 Posts
    #24  
    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.
  25. realwarder's Avatar
    Member

    Posts
    1,090 Posts
    #25  
    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.
Page 1 of 2 12 LastLast

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 Devices
    Replies: 35
    Last Post: 09-11-2012, 12:58 PM
  5. Replies: 0
    Last Post: 09-10-2012, 06:21 AM

Posting Permissions