| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to open Excel sheet with more than 64000 lines
I am using Office 2002, and have received Excel files with greater than 64000
line items. Is there a way , or an update, with Excel 2002 to open files this large? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to open Excel sheet with more than 64000 lines
You need to upgrade to Excel 2007.
"mgoehring" wrote: I am using Office 2002, and have received Excel files with greater than 64000 line items. Is there a way , or an update, with Excel 2002 to open files this large? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to open Excel sheet with more than 64000 lines
Yes, but not more than 65536. For that you would need Excel 2007.
-- David Biddulph "mgoehring" wrote in message ... I am using Office 2002, and have received Excel files with greater than 64000 line items. Is there a way , or an update, with Excel 2002 to open files this large? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to open Excel sheet with more than 64000 lines
If the file is really an excel file (.xls*), you could ask the sender to put
portions of the data on different sheets. Then save the file in xl97-2003 format and resend it to you. If the file is a text file (.csv or .txt???), then you could do your own splitting and import the data multiple times. mgoehring wrote: I am using Office 2002, and have received Excel files with greater than 64000 line items. Is there a way , or an update, with Excel 2002 to open files this large? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When will Excel expand the 64000 row limit? | Excel Discussion (Misc queries) | |||
| pasting beyond 64000 lines | New Users to Excel | |||
| how many lines per sheet in excel 2003 | Excel Discussion (Misc queries) | |||
| How can I have more than 64000 rows in one sheet? | Excel Discussion (Misc queries) | |||
| How do I get rid of spare lines in an excel spread sheet? | Excel Worksheet Functions | |||
Linear Mode
