Reader Phil Smith (in a comment to a previous blog item) asks: My wife has an HP IPAQ 1910 PDA, running the older version of ActiveSync that allows backups and restores. The battery died and it lost everything. Can you tell me what is the latest version of ActiveSync that includes backups and restores. Also, what is the extension on the backups. I have to hook up an old hard drive to find the backup and don’t know what to look for.

I thought the response to this might be of enough general interest to merit its own blog item. So, here are my responses.

• The most current production ActiveSync 4.2 actually provides Backup/Restore functions for pre-Windows Mobile 5 devices. It does not provide it for current generation Windows Mobile 5 devices though.

• The extension for backup files created using ActiveSync’s Backup/Restore feature is .stg. In fact, unless you chose something different the default backup filename is backup.stg.
• Click -> ActiveSync 4.2 web page for the current version. Veresion 3.8 seems to have disappeared from Microsoft’s site. So, if 4.2 doesn’t work for you, you can find version 3.6 here -> ActiveSync 3.6.

Reader P.L. asks: I just purchased a Treo 700W from Verizon. Excel Mobile will not let me save updates to most of the Excel files that I have synced to the handheld. It gives me a window that says unsupported content and formatting will be lost if I save the workbook and then it will not let me save it. I’m forced into a ‘Save As’ function. I cannot figure out what is unsupported and cannot find any documentation on the subject. Can you help?

I’m guessing a few details are missing from this story and will assume the following additional details…

• The problem spreadsheets were created using a full version of Excel on a desktop or notebook.
• This spreadsheet was copied to the Pocket PC Phone Edition (Treo 700w)
• The spreadsheet was modified (new data and/or change existing data in cells)

If this is the case, then this is, believe it or not, normal (though undesirable). Word Mobile and Excel Mobile only provide small subsets of the features available in the full version for Windows XP. And, despite years of pleading from many users (including me), neither Mobile application provides what is called non-destructive round-tripping. So, if you use, for example, unsupported features like macros or unsupported statistical functions on the original version created using the full version of Excel 2003, these features will not be preserved if the spreadsheet is modified on the Pocket PC and then saved back to the same file.

The workaround is to adopt a workflow model that takes this into account. For example, let’s say we have an Excel 2003 spreadsheet file named FOO.XLS. Instead of copying it directly to the Pocket PC, we make a copy named FOO-MOBILE.XLS on the desktop first. This renamed copy is copied over to the Pocket PC where it is worked on. When saving the modified spreadsheet back to the Pocket PC, you can ignore the warning and save it. This modified FOO-MOBILE.XLS is then copied back to the desktop PC where the data can either be manually or automatically (using additional macros or VBA scripts) merged back into the original version.

I am not pleased with this situation either. A number of people including me have been telling Microsoft’s Windows Mobile product management group that it is critical to have non-destructive round-tripping for Excel Mobile and Word Mobile. However, we have always been told that major customers have not identified this as a high priority issue. If this is an issue for you (as it is for me), you should definitely let Microsoft know through your Microsoft account executives, at conferences, or the Microsoft wish request.

Reader OdL asks:

• retrieve projectinformation from our database
• walk through a wizzerd to fill in information
• make a CAD-drawing, saved as WMF
• print report including the drawing “on the spot” (HP Deskjet 450, IRDa)
• transmit information & drawings, so the server can generate certificates for authoriation

• Bachman PrintBoy 7.0
• Westtek JETCET