From: Alan on 31 Dec 2005 18:27 I have a few sheets that have some programming in them and that isn't supported. When creating new sheets I try to avoid it now. Other than that I haven't come across anything that's been a problem. "Clinton Fitch, Clinton Fitch (Dot) Com!" <management(a)NOSPAMMINGME.clintonfitch.com> wrote in message news:%23vbmWolDGHA.3984(a)TK2MSFTNGP14.phx.gbl... > Wendy, > > It sounds like you have run into one of the limitations of Excel Mobile. > Unfortunately it does not support some of the formatting that your desktop > Excel produces. > > As Alan recommended, you may want to investigate SoftMaker's PlanMaker. > It is compatible with Excel files and I personally haven't found an Excel > feature/formula/content that it doesn't support. You can read a review of > it on my site by going to http://www.clintonfitch.com/reviews. > > Regards, > > -- > Clinton Fitch > Principle / Senior Editor > Clinton Fitch (Dot) Com! > http://www.clintonfitch.com > Your Home for Windows Mobile Pocket PC and Smartphone Views & Reviews > > A Pocket PC Magazine "Best Site" > > "Wendy Phillips" <wphillips(a)answertechnology.com> wrote in message > news:OlSLIdjDGHA.1816(a)TK2MSFTNGP11.phx.gbl... >> Newbie here so I apologize ahead of time for any dumb question(s) I >> ask... >> >> I jut got a Dell Axim X51 running Windows Mobile 5.0. I am a teacher and >> use Excel as my gradebook. Whenever I edit a spreadsheet that I have >> edited >> on my PC (running Excel 2000), I get the following message... >> >> "Unsupported content and formatting may be lost if you save this >> workbook. >> Tap save as to create a copy or replace the file..." >> >> It does this with even the simplest of workbooks (no macros, no >> formatting, >> just a single cell of text data). I can do a save as and write it over >> the >> original workbook but it's a cumbersome process, and I don't know what >> formatting and content I may be losing. Is this a result of the desktop >> version of Excel I'm using or some converseion setting, or is it the way >> it >> was designed to work. >> >> Would love to hear from anyone experienced with Excel Mobile. >> >> W. Phillips >> >> > >
From: Clinton Fitch, Clinton Fitch (Dot) Com! on 31 Dec 2005 20:48 Alan, What do you mean by programming? I only have some formulas - some of them rather complex - and I haven't run into any issues. Regards, -- Clinton Fitch Principle / Senior Editor Clinton Fitch (Dot) Com! http://www.clintonfitch.com Your Home for Windows Mobile Pocket PC and Smartphone Views & Reviews A Pocket PC Magazine "Best Site" "Alan" <alan(a)hidden.email> wrote in message news:dp77gr$5p1$2(a)newsg1.svr.pol.co.uk... >I have a few sheets that have some programming in them and that isn't >supported. When creating new sheets I try to avoid it now. > > Other than that I haven't come across anything that's been a problem. > > > "Clinton Fitch, Clinton Fitch (Dot) Com!" > <management(a)NOSPAMMINGME.clintonfitch.com> wrote in message > news:%23vbmWolDGHA.3984(a)TK2MSFTNGP14.phx.gbl... >> Wendy, >> >> It sounds like you have run into one of the limitations of Excel Mobile. >> Unfortunately it does not support some of the formatting that your >> desktop Excel produces. >> >> As Alan recommended, you may want to investigate SoftMaker's PlanMaker. >> It is compatible with Excel files and I personally haven't found an Excel >> feature/formula/content that it doesn't support. You can read a review >> of it on my site by going to http://www.clintonfitch.com/reviews. >> >> Regards, >> >> -- >> Clinton Fitch >> Principle / Senior Editor >> Clinton Fitch (Dot) Com! >> http://www.clintonfitch.com >> Your Home for Windows Mobile Pocket PC and Smartphone Views & Reviews >> >> A Pocket PC Magazine "Best Site" >> >> "Wendy Phillips" <wphillips(a)answertechnology.com> wrote in message >> news:OlSLIdjDGHA.1816(a)TK2MSFTNGP11.phx.gbl... >>> Newbie here so I apologize ahead of time for any dumb question(s) I >>> ask... >>> >>> I jut got a Dell Axim X51 running Windows Mobile 5.0. I am a teacher >>> and >>> use Excel as my gradebook. Whenever I edit a spreadsheet that I have >>> edited >>> on my PC (running Excel 2000), I get the following message... >>> >>> "Unsupported content and formatting may be lost if you save this >>> workbook. >>> Tap save as to create a copy or replace the file..." >>> >>> It does this with even the simplest of workbooks (no macros, no >>> formatting, >>> just a single cell of text data). I can do a save as and write it over >>> the >>> original workbook but it's a cumbersome process, and I don't know what >>> formatting and content I may be losing. Is this a result of the desktop >>> version of Excel I'm using or some converseion setting, or is it the way >>> it >>> was designed to work. >>> >>> Would love to hear from anyone experienced with Excel Mobile. >>> >>> W. Phillips >>> >>> >> >> > >
From: Alan on 31 Dec 2005 21:27 Macros- essentialy Visual Basic now, Formulae are no problem. "Clinton Fitch, Clinton Fitch (Dot) Com!" <management(a)NOSPAMMINGME.clintonfitch.com> wrote in message news:ul2mAVnDGHA.2036(a)TK2MSFTNGP14.phx.gbl... > Alan, > > What do you mean by programming? > > I only have some formulas - some of them rather complex - and I haven't > run into any issues. > > Regards, > > > -- > Clinton Fitch > Principle / Senior Editor > Clinton Fitch (Dot) Com! > http://www.clintonfitch.com > Your Home for Windows Mobile Pocket PC and Smartphone Views & Reviews > > A Pocket PC Magazine "Best Site" > > "Alan" <alan(a)hidden.email> wrote in message > news:dp77gr$5p1$2(a)newsg1.svr.pol.co.uk... >>I have a few sheets that have some programming in them and that isn't >>supported. When creating new sheets I try to avoid it now. >> >> Other than that I haven't come across anything that's been a problem. >> >> >> "Clinton Fitch, Clinton Fitch (Dot) Com!" >> <management(a)NOSPAMMINGME.clintonfitch.com> wrote in message >> news:%23vbmWolDGHA.3984(a)TK2MSFTNGP14.phx.gbl... >>> Wendy, >>> >>> It sounds like you have run into one of the limitations of Excel Mobile. >>> Unfortunately it does not support some of the formatting that your >>> desktop Excel produces. >>> >>> As Alan recommended, you may want to investigate SoftMaker's PlanMaker. >>> It is compatible with Excel files and I personally haven't found an >>> Excel feature/formula/content that it doesn't support. You can read a >>> review of it on my site by going to http://www.clintonfitch.com/reviews. >>> >>> Regards, >>> >>> -- >>> Clinton Fitch >>> Principle / Senior Editor >>> Clinton Fitch (Dot) Com! >>> http://www.clintonfitch.com >>> Your Home for Windows Mobile Pocket PC and Smartphone Views & Reviews >>> >>> A Pocket PC Magazine "Best Site" >>> >>> "Wendy Phillips" <wphillips(a)answertechnology.com> wrote in message >>> news:OlSLIdjDGHA.1816(a)TK2MSFTNGP11.phx.gbl... >>>> Newbie here so I apologize ahead of time for any dumb question(s) I >>>> ask... >>>> >>>> I jut got a Dell Axim X51 running Windows Mobile 5.0. I am a teacher >>>> and >>>> use Excel as my gradebook. Whenever I edit a spreadsheet that I have >>>> edited >>>> on my PC (running Excel 2000), I get the following message... >>>> >>>> "Unsupported content and formatting may be lost if you save this >>>> workbook. >>>> Tap save as to create a copy or replace the file..." >>>> >>>> It does this with even the simplest of workbooks (no macros, no >>>> formatting, >>>> just a single cell of text data). I can do a save as and write it over >>>> the >>>> original workbook but it's a cumbersome process, and I don't know what >>>> formatting and content I may be losing. Is this a result of the >>>> desktop >>>> version of Excel I'm using or some converseion setting, or is it the >>>> way it >>>> was designed to work. >>>> >>>> Would love to hear from anyone experienced with Excel Mobile. >>>> >>>> W. Phillips >>>> >>>> >>> >>> >> >> > >
From: Beverly Howard [Ms-MVP/MobileDev] on 31 Dec 2005 23:10 Here's a good reference site http://ogasawalrus.com/mobileviews/mobilefaqs/PocketExcel In addition, using the above, I extrapolated the following functions that are _not_ supported in pexcel Beverly Howard [MS MVP-Mobile Devices] ACCRINT ACCRINTM ACOSH ADDRESS AMORDEGRC AMORLINC AREAS ASC ASINH ATANH AVEDEV AVERAGEA BAHTTEXT BESSELI BESSELJ BESSELK BESSELY BETADIST BETAINV BIN2DEC BIN2HEX BIN2OCT BINOMDIST CEILING CELL CHAR CHIDIST CHIINV CHITEST CLEAN CODE COLUMN COMBIN COMPLEX CONCATENATE CONFIDENCE CONVERT CORREL COSH COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD COVAR CRITBINOM CUMIPMT CUMPRINC DAYS360 DB DEC2BIN DEC2HEX DEC2OCT DELTA DEVSQ DISC DMIN DOLLAR DOLLARDE DOLLARFR DURATION EDATE EFFECT EOMONTH ERF ERFC EUROCONVERT EVEN EXPONDIST FACTDOUBLE FDIST FINV FISHER FISHERINV FIXED FLOOR FORECAST FREQUENCY FTEST FVSCHEDULE GAMMADIST GAMMAINV GAMMALN GCD GEOMEAN GESTEP GETPIVOTDATA GROWTH HARMEAN HEX2BIN HEX2DEC HEX2OCT HYPERLINK HYPGEOMDIST IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM INDIRECT INFO INTERCEPT INTRATE IPMT ISEVEN ISODD ISPMT ISREF JIS KURT LARGE LCM LINEST LOGEST Logical LOGINV LOGNORMDIST LOOKUP MAXA MDETERM MDURATION MEDIAN MINA MINVERSE MIRR MMULT MODE MROUND MULTINOMIAL NEGBINOMDIST NETWORKDAYS NOMINAL NORMDIST NORMINV NORMSDIST NORMSINV OCT2BIN OCT2DEC OCT2HEX ODD ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD OFFSET PEARSON PERCENTILE PERCENTRANK PERMUT PHONETIC POISSON PPMT PRICE PRICEDISC PRICEMAT PROB QUARTILE QUOTIENT RANDBETWEEN RANK RECEIVED ROMAN ROUNDDOWN ROUNDUP ROW RSQ RTD SEARCH SERIESSUM SIGN SINH SKEW SLOPE SMALL SQL.REQUEST SQRTPI STANDARDIZE Statistical STDEVA STDEVPA STEYX SUBTOTAL SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TANH TBILLEQ TBILLPRICE TBILLYIELD TDIST TEXT TINV TODAY TRANSPOSE TREND TRIMMEAN TTEST TYPE VARA VARPA VDB WEEKDAY WEEKNUM WEIBULL WORKDAY XIRR XNPV YEARFRAC YIELD YIELDDISC YIELDMAT ZTEST
From: Beverly Howard [Ms-MVP/MobileDev] on 31 Dec 2005 23:13 Also, be _very_ aware of the danger of "round tripping" complex documents... Since the pocket versions can't handle the complex functions, they are "stripped" when they are editied on the ppc... subsequently, when these files are synced back to the pc, all of the complexity in the originals on the pc are lost... do not sync the originals... only copies. Beverly Howard [MS MVP-Mobile Devices]
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Active Sync Error 86000209 Next: Need Phone Dialer Application for WM5 |