file transfer to pocket pc

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 !
> >>
> >>
> >>
>
>
>

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 !
>> >>
>> >>
>> >>
>>
>>
>>

Nick;

After a little more work on the file, it appears that sheets that have
protection turned on with a password will not transfer the data to the pocket
pc. As you indicated the sheet will transfer however it will not have the
data. If the sheet is protected without a password it transfers just fine.
Thanks for your insights.



"Nick Hodge" wrote:

> 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 !
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Nick;

After a little more work on the file, it appears that sheets that have
protection turned on with a password will not transfer the data to the pocket
pc. As you indicated the sheet will transfer however it will not have the
data. If the sheet is protected without a password it transfers just fine.
Thanks for your insights

"Nick Hodge" wrote:

> 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 !
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>