View Single Post
  #8   Report Post  
Ben
 
Posts: n/a
Default


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
HIS


"Ben" wrote in message
...
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
HIS


"Ben" wrote in message
...
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
HIS


"Ben" wrote in message
...
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 !