Max no of row

T

Taeho Lee

I have to import really big spreadsheet and Excel does
not bring the whole rows. What is the maximum number of
rows that can be imported ?
 
J

John Wilson

Taeho,
What is the maximum number of rows that can be imported ?
Click to expand...
You can import as many as you like but each worksheet in Excel
can only have 65536 rows.
If you need more, you'll have to split your data into separate
worksheets or maybe use Access.

John
 

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

Indenting every other paragraph in Word at the same time? 0
Need Help with a VBA subroutine 0
Dealing with a Pivot Table (when I don't want to) 0
Integrating information from Word to Excel (not mail merge) 1
Repeating a row other than the 1st row as the header row in a table from next page 1
Remove duplicate items in the table 2
Excel --> Word 4
Need help merging Excel into Publisher Booklet w 2 columns 0

Top