Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Excel 2007 still have the 65536 raw limit?
I have a big text file to open. Excel 2007 should be able to handle
more data then the older versions. However, 2007 still only imported 65536 raws for me. (I am using Windows XP.) Does anyone know why? Is there any way to overcome this problem? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Excel 2007 still have the 65536 raw limit?
Maybe that was the number of rows in the incoming file?
" wrote: I have a big text file to open. Excel 2007 should be able to handle more data then the older versions. However, 2007 still only imported 65536 raws for me. (I am using Windows XP.) Does anyone know why? Is there any way to overcome this problem? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Excel 2007 still have the 65536 raw limit?
Check your import macro to see if it sets the limit at 65536. xl2007 does
exceed the old limits so the answer is some where between your code and the source file. " wrote: I have a big text file to open. Excel 2007 should be able to handle more data then the older versions. However, 2007 still only imported 65536 raws for me. (I am using Windows XP.) Does anyone know why? Is there any way to overcome this problem? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Excel 2007 still have the 65536 raw limit?
I think that 2007 has a million rows or whatever it is, but only if the file
was created in 2007. If it's been created in an earlier version the same restrictions that apply to that version still stand. You can probably copy paste it in, but you may need to do it in sections, ie row 1 to 65536, 65537 to whatever etc. Regards, Alan. wrote in message ... I have a big text file to open. Excel 2007 should be able to handle more data then the older versions. However, 2007 still only imported 65536 raws for me. (I am using Windows XP.) Does anyone know why? Is there any way to overcome this problem? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Excel 2007 still have the 65536 raw limit?
Thank you guys. My original file is txt file and it does has more than
65537 raws. After I imported the data, (it only gave me 65537 raws), I can not insert more raws, this also happens if I create an empty file, copy and past the data.. JLGWhiz , can you be more specific on the import macro? How to check it? Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Excel 2007 still have the 65536 raw limit?
I just did a File, Open of a long text file and all 270,000 rows came in
fine. If you are "importing" data into an existing sheet, using the Data commands, you are limited to the rows in that sheet. And if it in the XLS format that limit is 65k rows. -- Jim wrote in message ... | Thank you guys. My original file is txt file and it does has more than | 65537 raws. | After I imported the data, (it only gave me 65537 raws), I can not | insert more raws, this also happens if I create an empty file, copy | and past the data.. | | JLGWhiz , can you be more specific on the import macro? How to check | it? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 65536 rows-convert | Excel Discussion (Misc queries) | |||
Is there an array size limit for MMULT or MINVERSE in excel 2007? | Excel Worksheet Functions | |||
Row Limit 65536 | Excel Discussion (Misc queries) | |||
Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ? | Excel Discussion (Misc queries) | |||
Make the row limit of excel flexible -not fixed at 65536. | Excel Discussion (Misc queries) |