Why can't I get more than 16,384 rows in Excel X for Mac?

[Mark Weinberg]

I want to creat a big spreadsheet with multiple columns and over
36,000 rows, but I can't seem to do it in my Excel X for the Mac.
Here's the situation: I have received a large spreadsheet in three
parts from my associate who has saved it in Microsoft Excel 5.0. Two
of the three spreadsheets have 16,384 rows and one has 3,302 rows (for
a total of 36,069 rows). Now, I am trying to cut and paste all three
of these spreadsheets into one single spreadsheet in my Mac Excel X.
When I do it, it looks like it works (it saves it o.k, and the rows
all appear to be in the single Excel X spreadsheet), but then I save
the file and close it and then open it and only 16,384 rows show up.
Is this the limit in rows for Excel X, and if so, what do I have to
purchase to solve this problem? Thanks. Mark Weinberg --

 

[Jim Gordon MVP]

Hi Mark,

The number of rows in Excel 5 and Excel 2004 is the same: 65,536 rows on
each worksheet. There is no limit (other than memory and processor
power and the amount of time you have) to the number of worksheets that
can be in a single workbook. Each workbook has the potential to be
infinely large.

There are lots of ways to move stuff around in Excel. Did you use
Edit>Cut, Apple+C, Edit>Copy, Copy to the Scrapbook, or some other
method to copy? When you pasted, did you move the cursor to the bottom
of the range of data before you pasted? Did you use a simple paste or
paste special?

-Jim

 

[Bob Greenblatt]

I want to creat a big spreadsheet with multiple columns and over
36,000 rows, but I can't seem to do it in my Excel X for the Mac.
Here's the situation: I have received a large spreadsheet in three
parts from my associate who has saved it in Microsoft Excel 5.0. Two
of the three spreadsheets have 16,384 rows and one has 3,302 rows (for
a total of 36,069 rows). Now, I am trying to cut and paste all three
of these spreadsheets into one single spreadsheet in my Mac Excel X.
When I do it, it looks like it works (it saves it o.k, and the rows
all appear to be in the single Excel X spreadsheet), but then I save
the file and close it and then open it and only 16,384 rows show up.
Is this the limit in rows for Excel X, and if so, what do I have to
purchase to solve this problem? Thanks. Mark Weinberg --

Mark,

In addition to Jim's suggestions, make sure you are saving the workbook as
an Excel workbook, rather than an earlier version of Excel. If for some
reason the workbook arrived in Excel 4 format, the file will be truncated
to 16K rows.