I've had a look at the files, and BOAC's diagnosis is spot on. Between the Ipaq and the PC, they are getting "Macroised". It's a
VB macro that can't be removed, and it screws the file up for subsequent use on the Ipaq.
Google, my friend, found a probable answer. Sadly, the location of the answer isn't one that can be "URL'ed" - or not by me, anyway, so here it is:
Originally Posted by dicky109 on Ozgrid
It was conversion settings in ActiveSync that was screwing everything up.
While I knew that you could insert Worksheets, I didn't realize there were different types, i.e. Worksheet, MS Excel 4 Macro. When I created a new worksheet and copied all the data, formulas & text from the old one, it worked perfectly. This led me to investigate in the Properties menu and finding the "Contents" tab, where it listed the existing sheets as "Excel 4.0 Macros" and the new sheet as "Worksheet", which is what I chose when inserting it. I opened & closed a couple of times to confirm that all was well, then synched the IPAQ, after which, the new sheet wouldn't work again. Upon checking "Contents", I saw that all sheets were now "Excel 4.0 Macros".
The light bulb went off in my addled mind and I realized that ActiveSynch must be converting to the Macro form. Upon checking the synchronization settings, the reinstall set Desktop to Pocket PC to convert to Pocket Excel format *.pxl or *.pxt extensions, which was supposed to convert back to *.xls when going from Pocket PC to Desktop. Whatever was happening, that wasn't it, so I turned off the desktop to Pocket PC conversions and set the Pocket PC to Desktop conversion to *.xls and everything works fine.