66,000 excel record limit
 

how do you split a file into two (in Excel) when you have exceeded the
limit of 66000 lines. please advise.

thanks,

pago

66,000 excel record limit
 

Maybe...
http://support.microsoft.com/kb/119770/en-us
Text Import Wizard Maximum Start Row Limitation of 32767
(see the Excel 97 section near the bottom)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



wrote in message
how do you split a file into two (in Excel) when you have exceeded the
limit of 66000 lines. please advise.
thanks,
pago

66,000 excel record limit
 

I'd open the file in Notepad and split it there.

Then do multiple imports.

wrote:

how do you split a file into two (in Excel) when you have exceeded the
limit of 66000 lines. please advise.

thanks,

pago

--

Dave Peterson

66,000 excel record limit
 

You might find this site useful in your stuation:

http://support.microsoft.com/default...b;en-us;120596


An alternative to consider is to upgrade to XL2007, which has 1
million rows.


Hope this helps.


Pete




On Mar 15, 12:42 pm, wrote:
how do you split a file into two (in Excel) when you have exceeded the
limit of 66000 lines. please advise.

thanks,

pago

66,000 excel record limit
 

page

Have a look here for VBA code to spread over multiple sheets.

http://support.microsoft.com/default...;en-us;Q120596


Gord Dibben MS Excel MVP

On 15 Mar 2007 05:42:15 -0700, wrote:


how do you split a file into two (in Excel) when you have exceeded the
limit of 66000 lines. please advise.

thanks,

pago