Home |
Search |
Today's Posts |
#1
|
|||
|
|||
file transfer to pocket pc
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 ! |
#2
|
|||
|
|||
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 ! |
#3
|
|||
|
|||
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 ! |
#5
|
|||
|
|||
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 ! |
#6
|
|||
|
|||
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 ! |
#7
|
|||
|
|||
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 ! |
#8
|
|||
|
|||
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 ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Is there a toolbar settings file I can transfer to my new PC? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |