Prev: BT for serial apps (port close timeout)
Next: BeanFinder(c) Update - Nov 13 2009
From: Ed from AZ on 12 Nov 2009 18:56
I have Excel 2000 on my laptop & Excel Mobile on my phone (WinMo 6.1,
XL Mobile 6.1). The synced file opens and saves fine on my laptop (no
conditional formatting or macros).

It opens okay on my phone, but doesn't want to save when I close. I
get a warning that "unsupported formatting may be lost". I hit SaveAs,
give it the same name, and replace the file. It saves as Excel
95/2003.

Is there any way around this conflict, short of upgrading to XL2007 on
my laptop?

Ed
From: Beverly Howard on 13 Nov 2009 10:59
>> a warning that "unsupported formatting may be lost" <<

That message should be related to using unsupported features which were
already in the file created on the pc when you first opened it...

Might take a look at http://bevhoward.com/pexcel.htm to see if perhaps
you are using one or more of these functions.

There may be other features not listed here as well.

A good test would be to create a simple worksheet table on the pc, open
it on the ppc and edit it, then see if you get the same message on close.

Beverly Howard
From: Todd Allcock on 13 Nov 2009 23:43
At 13 Nov 2009 09:59:59 -0600 Beverly Howard wrote:
> >> a warning that "unsupported formatting may be lost" <<
>
> That message should be related to using unsupported features which were
> already in the file created on the pc when you first opened it...


Starting (IIRC) with WM6, that message displays automatically when trying
to save any workbook not created on the device itself, regardless of the
functions used in the sheet (I have several sheets with no formulae at
all- just simple text/numeric "database" lists, and I still get the
warning after modifying those!)

I don't mind the message- it's a perfectly good warning. What I object
to is that there's no option to "save" anyway. I'm a big boy and I'm
aware of the risks, so I'd like the device to let me decide!

The options available when tapping "ok" on a modified sheet are; "Save
As" which saves the file with a different name, "Discard" which closes
the file without saving the changes made on the device, and "Cancel"
which dumps you back into the edited sheet without saving or closing.

You can save the sheet with the original file name but it requires
selecting "Save As", then editing the name back to the original file name
(by default "Save As" adds "(1)" at the end of the name,) tap "save" then
tap "ok" to the resultant "File exists. Overwrite?" dialog that pops up.



> Might take a look at http://bevhoward.com/pexcel.htm to see if perhaps
> you are using one or more of these functions.
>
> There may be other features not listed here as well.


Excellent reference, BTW, Bev!


> A good test would be to create a simple worksheet table on the pc, open
> it on the ppc and edit it, then see if you get the same message on close.



You do! :( The only way to avoid it is to create he sheet on the
device. For one sheet I update regularly, I kludged it by ceting a new
sheet on the device, and cut and pasted all cells from the synced sheet
to the "new" blank then saved it. Now the device thinks it's a sheet
created on the device (which it technically is) and no longer nags me
when I update it!


From: Todd Allcock on 13 Nov 2009 23:52
At 12 Nov 2009 15:56:12 -0800 Ed from AZ wrote:
> I have Excel 2000 on my laptop & Excel Mobile on my phone (WinMo 6.1,
> XL Mobile 6.1). The synced file opens and saves fine on my laptop (no
> conditional formatting or macros).
>
> It opens okay on my phone, but doesn't want to save when I close. I
> get a warning that "unsupported formatting may be lost". I hit SaveAs,
> give it the same name, and replace the file. It saves as Excel
> 95/2003.
>
> Is there any way around this conflict, short of upgrading to XL2007 on
> my laptop?


No, and upgrading to 2K7 won't help either. It's a "feature" designed to
protect the worksheet from having functionality stripped by the mobile
version of Excel. Only sheets orininally created by Excel Mobile are
immune from this behavior. (If it's only a few oft-used sheets that bug
you, you can try my kludge I mentioned in my reply to Bev: create a new
sheet on the device, cut and paste all the cells from the synced sheet
into the new sheet, save it, delete the original and rename the new one,
and now you have the same sheet, but since this one was "created" by
Excel Mobile, it won't nag you when saving it.)


From: Ed from AZ on 14 Nov 2009 10:14
Thanks, Bev and Todd. I guess I'll just live with what's it's doing -
since it's going to keep doing it!

Ed
 |  Next  |  Last
Pages: 1 2
Prev: BT for serial apps (port close timeout)
Next: BeanFinder(c) Update - Nov 13 2009