- 02-17-2013, 05:48 AM #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.
- 02-17-2013, 08:42 AM #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.
- 02-17-2013, 10:02 AM #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!!!!
02-17-2013, 10:41 AM #6
- 2 Posts
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, 11:09 AM #8
- 1,047 Posts
I've been opening Excel documents on WP8 and WP7 since it was launched over 2 years ago.
- 02-17-2013, 12:06 PM #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!!!
- 02-17-2013, 12:34 PM #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.)
- 02-17-2013, 01:10 PM #14
- 02-17-2013, 01:24 PM #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???
- 02-17-2013, 05:38 PM #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
02-18-2013, 10:32 AM #18
- 2 Posts
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, 04:44 PM #19
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-19-2013, 01:50 AM #21
- 796 Posts
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.
02-19-2013, 06:18 PM #22
- 1,047 Posts
- 02-19-2013, 07:36 PM #23
02-19-2013, 08:50 PM #24
- 93 Posts
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, 09:35 PM #25
- 1,164 Posts
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.
- By Sandrot in forum HTC RadarReplies: 0Last Post: 02-02-2013, 04:10 PM
- By rsshirlevel in forum Windows Phone AppsReplies: 0Last Post: 01-30-2013, 03:29 AM
- By cbarry1 in forum Nokia Lumia 820Replies: 3Last Post: 01-17-2013, 05:23 PM
- By andrelamont in forum Upcoming & Rumored DevicesReplies: 35Last Post: 09-11-2012, 12:58 PM
- By Snow in forum Windows Phone 7Replies: 0Last Post: 09-10-2012, 06:21 AM