How to open Excel sheet with more than 64000 lines

M

mgoehring

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked 75 MB excel files - HELP 2
Cell data entering slow! 0
Excel opening 1
How to create a bubble chart with more than 2 variables. 0
Embed the same Excel multiple times 0
dynamic data range in pivot tables excel 2007 1
Possible to Combine reports to's to a single box? 0
importing accounting data am limited to 16384 line - why? 2

Top