file transfer to pocket pc

[Ben]

Is there a size limit of an excel file when transfering to a pocket PC.
I have a file with many sheets and only the first 4 to 5 sheet will transfer
to hand held. Mobile 2003 2nd addition.
--
Thank you !

[Nick Hodge]

Ben

It may be more a size issue than sheets. I just transferred a 16 sheet
workbook across fine, but it had next to no data in

Bear in mind too the Excel for PPC grid is only 16384x256 meaning sheets
that use more than that may not transfer at all. If you want to send me a
test file I'll give it a go

PPC2003 1st Ed
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Ben" <Ben@discussions.microsoft.com> wrote in message
news:23EDDE4E-253B-4451-A2D0-E66A8F6E058E@microsoft.com...
> Is there a size limit of an excel file when transfering to a pocket PC.
> I have a file with many sheets and only the first 4 to 5 sheet will
> transfer
> to hand held. Mobile 2003 2nd addition.
> --
> Thank you !

[Ben]

Nick:
Thanks for your input. The file has around 24-26 sheets with alot of formuls
that pull data from the other sheets. I would be happy to send you a file to
work with I just need to know how/where to send it.

"Nick Hodge" wrote:

> Ben
>
> It may be more a size issue than sheets. I just transferred a 16 sheet
> workbook across fine, but it had next to no data in
>
> Bear in mind too the Excel for PPC grid is only 16384x256 meaning sheets
> that use more than that may not transfer at all. If you want to send me a
> test file I'll give it a go
>
> PPC2003 1st Ed
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:23EDDE4E-253B-4451-A2D0-E66A8F6E058E@microsoft.com...
> > Is there a size limit of an excel file when transfering to a pocket PC.
> > I have a file with many sheets and only the first 4 to 5 sheet will
> > transfer
> > to hand held. Mobile 2003 2nd addition.
> > --
> > Thank you !
>
>
>

[Nick Hodge]

Ben

My email is below the signature but take out all the bits in CAPS

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Ben" <Ben@discussions.microsoft.com> wrote in message
news:8875A529-369C-43C3-9C86-721D09E244F2@microsoft.com...
> Nick:
> Thanks for your input. The file has around 24-26 sheets with alot of
> formuls
> that pull data from the other sheets. I would be happy to send you a file
> to
> work with I just need to know how/where to send it.
>
> "Nick Hodge" wrote:
>
>> Ben
>>
>> It may be more a size issue than sheets. I just transferred a 16 sheet
>> workbook across fine, but it had next to no data in
>>
>> Bear in mind too the Excel for PPC grid is only 16384x256 meaning sheets
>> that use more than that may not transfer at all. If you want to send me a
>> test file I'll give it a go
>>
>> PPC2003 1st Ed
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>> "Ben" <Ben@discussions.microsoft.com> wrote in message
>> news:23EDDE4E-253B-4451-A2D0-E66A8F6E058E@microsoft.com...
>> > Is there a size limit of an excel file when transfering to a pocket PC.
>> > I have a file with many sheets and only the first 4 to 5 sheet will
>> > transfer
>> > to hand held. Mobile 2003 2nd addition.
>> > --
>> > Thank you !
>>
>>
>>

[Ben]

Nick:
your help was great! after I removed the sheet protection the file
transfered to my pocket pc just fine.

I appreciate your help!

"Nick Hodge" wrote:

> Ben
>
> My email is below the signature but take out all the bits in CAPS
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:8875A529-369C-43C3-9C86-721D09E244F2@microsoft.com...
> > Nick:
> > Thanks for your input. The file has around 24-26 sheets with alot of
> > formuls
> > that pull data from the other sheets. I would be happy to send you a file
> > to
> > work with I just need to know how/where to send it.
> >
> > "Nick Hodge" wrote:
> >
> >> Ben
> >>
> >> It may be more a size issue than sheets. I just transferred a 16 sheet
> >> workbook across fine, but it had next to no data in
> >>
> >> Bear in mind too the Excel for PPC grid is only 16384x256 meaning sheets
> >> that use more than that may not transfer at all. If you want to send me a
> >> test file I'll give it a go
> >>
> >> PPC2003 1st Ed
> >> --
> >> HTH
> >> Nick Hodge
> >> Microsoft MVP - Excel
> >> Southampton, England
> >> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >>
> >>
> >> "Ben" <Ben@discussions.microsoft.com> wrote in message
> >> news:23EDDE4E-253B-4451-A2D0-E66A8F6E058E@microsoft.com...
> >> > Is there a size limit of an excel file when transfering to a pocket PC.
> >> > I have a file with many sheets and only the first 4 to 5 sheet will
> >> > transfer
> >> > to hand held. Mobile 2003 2nd addition.
> >> > --
> >> > Thank you !
> >>
> >>
> >>
>
>
>

[Nick Hodge]

Ben

Thanks for taking the trouble to close this off.

For Info, it was the sheet protection on the Excel sheets that stopped it
transferring data to Excel for PPC. The sheets came through ok, just no data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Ben" <Ben@discussions.microsoft.com> wrote in message
news:D921C500-20C1-4581-A1C2-3FE2763BE5AE@microsoft.com...
> Nick:
> your help was great! after I removed the sheet protection the file
> transfered to my pocket pc just fine.
>
> I appreciate your help!
>
> "Nick Hodge" wrote:
>
>> Ben
>>
>> My email is below the signature but take out all the bits in CAPS
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>> "Ben" <Ben@discussions.microsoft.com> wrote in message
>> news:8875A529-369C-43C3-9C86-721D09E244F2@microsoft.com...
>> > Nick:
>> > Thanks for your input. The file has around 24-26 sheets with alot of
>> > formuls
>> > that pull data from the other sheets. I would be happy to send you a
>> > file
>> > to
>> > work with I just need to know how/where to send it.
>> >
>> > "Nick Hodge" wrote:
>> >
>> >> Ben
>> >>
>> >> It may be more a size issue than sheets. I just transferred a 16
>> >> sheet
>> >> workbook across fine, but it had next to no data in
>> >>
>> >> Bear in mind too the Excel for PPC grid is only 16384x256 meaning
>> >> sheets
>> >> that use more than that may not transfer at all. If you want to send
>> >> me a
>> >> test file I'll give it a go
>> >>
>> >> PPC2003 1st Ed
>> >> --
>> >> HTH
>> >> Nick Hodge
>> >> Microsoft MVP - Excel
>> >> Southampton, England
>> >> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>> >>
>> >>
>> >> "Ben" <Ben@discussions.microsoft.com> wrote in message
>> >> news:23EDDE4E-253B-4451-A2D0-E66A8F6E058E@microsoft.com...
>> >> > Is there a size limit of an excel file when transfering to a pocket
>> >> > PC.
>> >> > I have a file with many sheets and only the first 4 to 5 sheet will
>> >> > transfer
>> >> > to hand held. Mobile 2003 2nd addition.
>> >> > --
>> >> > Thank you !
>> >>
>> >>
>> >>
>>
>>
>>