Pocket PC FAQ Forums Forum Index Pocket PC FAQ Forums
The place to discuss Windows Mobile, Pocket PCs, Smartphones, Handheld PCs, Windows CE and More!
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Excel Mobile: file conversion problem
Goto page 1, 2  Next
 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Pocket PC FAQ Forums Forum Index -> Windows Mobile 5.0
View previous topic :: View next topic  
Author Message
Dlanod
Pocketeer


Joined: 22 Feb 2006
Posts: 2

PostPosted: Wed Feb 22, 2006 4:29 am    Post subject: Excel Mobile: file conversion problem Reply with quote

I have Excel 2003 on my PC, and Excel Mobile on by iPAQ hx2490 (Windows Mobile 5).
This is my problem:
1.) I am editing a very simple Excel file on my PC.
2.) I am syncing the Excel file to the Pocket PC.
3.) I am opening and editing the Excel file on the Pocket PC
4.) When I want to save the Excel file on the Pocket PC I get the following message: "Unsupported content and formatting may be lost if you save this workbook. Tap save to create a copy or replace the file. Tap Discard to close the workbook without saving changes".

This means that for any editing done on the Pocket PC I have to save the file as a new filename. How can I avoid this? Even the simplest Excel sheet has this problem. (I am told it works OK on other Windows Mobile 5 Pocket PCs). I see that Excel 2003 does not have the option to save a file as a Pocket Excel file. Word 2003 can save files as Pocket Word.
Back to top
View user's profile Send private message
ChrisDeHerrera
Site Admin


Joined: 01 Feb 2000
Posts: 7017
Location: Los Angeles, CA, USA

PostPosted: Wed Feb 22, 2006 10:00 am    Post subject: Reply with quote

Hi,
This is by design. If you were not warned you would see an unpleasant suprise when you opened the file on the desktop and formatting was missing.

Pocket Excel is behind Pocket Word in Windows Mobile 5.0. Pocket Word supports keeping all the formatting even if the device does not support it.
_________________
Chris De Herrera
Microsoft MVP - Mobile Devices & Tablet PC
http://www.pocketpcfaq.com- The most complete set of FAQs on Windows CE
http://www.tabletpctalk.com - Get the latest Tablet PC News
http://www.pocketpctalk.com - Get the latest Pocket PC News
http://www.mobilitytalk.com - Quickly view all the Pocket PC & Tablet PC News on one page
Back to top
View user's profile Send private message Visit poster's website
Dlanod
Pocketeer


Joined: 22 Feb 2006
Posts: 2

PostPosted: Wed Feb 22, 2006 11:39 pm    Post subject: Pocket Excel problem Reply with quote

Thanks for the answer. However, I think it can't be a problem of Excel Mobile not supporing the formatting. Even the simplest Excel sheet has this problem. One cell with one number, no formatting at all, gives this problem...
Also, a friend of me does not have this problem when both of us use the same Excel file. He is also using Pocket Excel on WM5.
Any more ideas...? Thanks!
Back to top
View user's profile Send private message
ChrisDeHerrera
Site Admin


Joined: 01 Feb 2000
Posts: 7017
Location: Los Angeles, CA, USA

PostPosted: Thu Feb 23, 2006 7:53 am    Post subject: Reply with quote

Hi,
Apparently Microsoft chose to warn all users about the issue with saving files losing formatting even if the file won't lose any.
_________________
Chris De Herrera
Microsoft MVP - Mobile Devices & Tablet PC
http://www.pocketpcfaq.com- The most complete set of FAQs on Windows CE
http://www.tabletpctalk.com - Get the latest Tablet PC News
http://www.pocketpctalk.com - Get the latest Pocket PC News
http://www.mobilitytalk.com - Quickly view all the Pocket PC & Tablet PC News on one page
Back to top
View user's profile Send private message Visit poster's website
vinniemac
Pocketeer


Joined: 13 Dec 2006
Posts: 1

PostPosted: Wed Dec 13, 2006 8:23 am    Post subject: Reply with quote

I'm having the same problem with Excel Mobile, but I don't have the option to save - only Save As with a new name. I've noticed that Active Sync (4.2) is not converting the files to pxl (or is this not done with the newer version?). Strangely, if I save the files in Open Office Spreadsheet, they convert ok and can be edited. Do Microsoft want to force me to use Open Office instead of Excel?

Vinnie
Back to top
View user's profile Send private message
ChrisDeHerrera
Site Admin


Joined: 01 Feb 2000
Posts: 7017
Location: Los Angeles, CA, USA

PostPosted: Fri Dec 15, 2006 7:05 pm    Post subject: Reply with quote

Hi,
ActiveSync 4.x no longer contains the .PXL and .PWD converters. Microsoft chose not to include the converters anymore.
_________________
Chris De Herrera
Microsoft MVP - Mobile Devices & Tablet PC
http://www.pocketpcfaq.com- The most complete set of FAQs on Windows CE
http://www.tabletpctalk.com - Get the latest Tablet PC News
http://www.pocketpctalk.com - Get the latest Pocket PC News
http://www.mobilitytalk.com - Quickly view all the Pocket PC & Tablet PC News on one page
Back to top
View user's profile Send private message Visit poster's website
addie
Pocketeer


Joined: 22 Dec 2006
Posts: 1

PostPosted: Fri Dec 22, 2006 11:22 am    Post subject: Reply with quote

Hi

I have the same problem with the O2 atom. In addition to this if you saved it as a new file, modifed it and then try to save it, it come back with an error message "An error occurred saving '...'."

It looks like its device dependent.

Addie
Back to top
View user's profile Send private message
sbolin
Pocketeer


Joined: 20 Jan 2007
Posts: 2

PostPosted: Sat Jan 20, 2007 11:27 am    Post subject: Error message "an error occurred saving ..." resol Reply with quote

I have recently been experiencing the same problem as described above, and I would love some assistance resolving it, as the Microsoft website does not list a solution.

Here are my specs:

Device: HP IPAQ rx1950
OS: Windows Mobile 5.1
Program: Excel Mobile

Problem:
Files that were originally created in Excel Mobile on my handheld device that have been saving without problems for the past 2 years have recently been giving me the error message when I open the file, make a change, and try to close it:

"An error occurred saving '...'."

It gives me the option to click OK or Cancel. If I click OK, it closes without saving, and if I click Cancel, it won't close.

Attempted solutions that failed:

1. Creating a copy on the handheld device, making the changes to that copy, then saving (same error message as above given on new file).

2. Creating a copy on my desktop computer, deleting the copy from my handheld device, then syncing the new copy to my handheld device using ActiveSync 4.1. I am able to open the file on my desktop, make changes, and save it there; however, it gives me the same error message when I sync the new file to the handheld device.

Any ideas or experience with this? I use these Excel spreadsheets on a daily basis, and it is very inconvenient to have to make all necessary changes on my desktop.

Thanks for your help!
Back to top
View user's profile Send private message
ChrisDeHerrera
Site Admin


Joined: 01 Feb 2000
Posts: 7017
Location: Los Angeles, CA, USA

PostPosted: Sat Jan 20, 2007 8:06 pm    Post subject: Reply with quote

Hi,
Can you send me the simplest version of the Excel file that is causing the problem?
_________________
Chris De Herrera
Microsoft MVP - Mobile Devices & Tablet PC
http://www.pocketpcfaq.com- The most complete set of FAQs on Windows CE
http://www.tabletpctalk.com - Get the latest Tablet PC News
http://www.pocketpctalk.com - Get the latest Pocket PC News
http://www.mobilitytalk.com - Quickly view all the Pocket PC & Tablet PC News on one page
Back to top
View user's profile Send private message Visit poster's website
surjun
Pocketeer


Joined: 25 Jan 2007
Posts: 2

PostPosted: Thu Jan 25, 2007 7:46 am    Post subject: Windows Mobile Excel is grief! Reply with quote

I am encountering the same problems of Excel file non-conversion on my O2 xda Orbit. Mobile Excel demands saving the original Excel file as ...(1) and then does not subsequently allow any modification of this file. Also, Active Sync 4.2 does not support the option of converting or not converting files as well as not allowing PDA system backup/restore. What kind of shambolic programmes are Microsoft leaving us with as the latest PDA software?!
Back to top
View user's profile Send private message
sbolin
Pocketeer


Joined: 20 Jan 2007
Posts: 2

PostPosted: Thu Jan 25, 2007 9:22 am    Post subject: Excel Mobile: file conversion problem Reply with quote

Yes, it's very strange, especially as I had been syncing these exact Excel files for over a year without any problems, and I haven't changed anything on either my desktop or handheld (no OS, software, or hardware upgrades on either side). It just stopped working one day...
Back to top
View user's profile Send private message
MattC455
Pocketeer


Joined: 26 Jan 2007
Posts: 1

PostPosted: Fri Jan 26, 2007 5:58 am    Post subject: Reply with quote

From a development point of view; this is an utter nightmare

My team have written a file catalog appliciation that can be accessed via PDAs running Windows Mobile 5. We have recently introduced excel files support into the catalog as per a request from a client, however immediately we found that if a spreadsheet was created/edited on a desktop PC, Excel Mobile would not allow the user to save to the original file; hence creating a headache for managing the file for auto-upload back to the file server (the filename can change as can the file's location on the device).

So far I have found that saving the spreadsheet using OpenOffice before sending to the device appears to avoid this message from occuring on the device, the only problem is a lot of my client's spreadsheets use "Splits" which OpenOffice Calc doesnt seem to support or convert.

What a nightmare. And this is not the first time we've hit a brick-wall thanks to shortcomings in Microsoft's core products.

If anyone knows a way to supress this message on the device, or even to convert the PC Excel file to fool 'Excel Mobile' into thinking its a 'supported format' then please clear our headaches Smile
Back to top
View user's profile Send private message
ChrisDeHerrera
Site Admin


Joined: 01 Feb 2000
Posts: 7017
Location: Los Angeles, CA, USA

PostPosted: Sun Jan 28, 2007 7:08 pm    Post subject: Reply with quote

Hi,
Microsoft created this message for all file saves because it destroys part of the data as part of the save process. There is no workaround.
_________________
Chris De Herrera
Microsoft MVP - Mobile Devices & Tablet PC
http://www.pocketpcfaq.com- The most complete set of FAQs on Windows CE
http://www.tabletpctalk.com - Get the latest Tablet PC News
http://www.pocketpctalk.com - Get the latest Pocket PC News
http://www.mobilitytalk.com - Quickly view all the Pocket PC & Tablet PC News on one page
Back to top
View user's profile Send private message Visit poster's website
g0lg0thaZA
Pocketeer


Joined: 15 Feb 2007
Posts: 1

PostPosted: Thu Feb 15, 2007 4:16 am    Post subject: an error occurred savin <file> - Temp0FOO Reply with quote

Hi

I had a similar problem not being able to save my excel mobile files, that used to work fine for years. I could find no other helpfull URL's in Google so here goes (hope I'm adding to it Very Happy

I was re-doing my Windows Mobile 5 phone and was restoring my files only to find it still would not save, then I noticed that there is a file pproximately the same size as the original one that went corrupt called Temp0FOO. I took a chance and deleted it and then I could save my files again as before.

Hope this works for you too.
Back to top
View user's profile Send private message
ChrisDeHerrera
Site Admin


Joined: 01 Feb 2000
Posts: 7017
Location: Los Angeles, CA, USA

PostPosted: Thu Feb 15, 2007 8:02 pm    Post subject: Reply with quote

Hi,
Thanks for the tip on the temp filename that can prevent users from saving Excel files!
_________________
Chris De Herrera
Microsoft MVP - Mobile Devices & Tablet PC
http://www.pocketpcfaq.com- The most complete set of FAQs on Windows CE
http://www.tabletpctalk.com - Get the latest Tablet PC News
http://www.pocketpctalk.com - Get the latest Pocket PC News
http://www.mobilitytalk.com - Quickly view all the Pocket PC & Tablet PC News on one page
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Pocket PC FAQ Forums Forum Index -> Windows Mobile 5.0 All times are GMT - 8 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Copyright 2001-2010, Chris De Herrera, All Rights Reserved

Powered by phpBB © 2001, 2005 phpBB Group