file transfer to pocket pc

[Guest]

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.

 

[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
(e-mail address removed)

 

[Guest]

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]

Ben

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

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]

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
(e-mail address removed)

 

[Guest]

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.

 

[Guest]

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