how do i overcome the xl2003 limit of 65,536 rows?

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

i have a workbook that requires about 9000 rows each month. As I look
at the data for a year, i will run out of rows in july or august. the
table has 9 columns in it. Is it best to start another worksheet when
i run out of rows, or start over in K3 [3 being the 1st row with
data]. i generate charts and a pivot table from the data. As everyone
at work has xl2003, going to xl 2007 or 2010 is not practicable. any
suggestion on how to best accomplish this?

Thanks,

Tonso
 
hi Tonso,

if you have "Access", you can put data into an Access table and analyze it with Excel
 
i have a workbook that requires about 9000 rows each month. As I look
at the data for a year, i will run out of rows in july or august. the
table has 9 columns in it. Is it best to start another worksheet when
i run out of rows, or start over in K3 [3 being the 1st row with
data]. i generate charts and a pivot table from the data. As everyone
at work has xl2003, going to xl 2007 or 2010 is not practicable. any
suggestion on how to best accomplish this?
Click to expand...

9000 rows is a lot, I would have one sheet per month.

As a side benefit, using 3-D references you'll find it much easier to
make summaries across all months.
 
i have a workbook that requires about 9000 rows each month. As I look
at the data for a year, i will run out of rows in july or august. the
table has 9 columns in it. Is it best to start another worksheet when
i run out of rows, or start over in K3 [3 being the 1st row with
data]. i generate charts and a pivot table from the data. As everyone
at work has xl2003, going to xl 2007 or 2010 is not practicable. any
suggestion on how to best accomplish this?
Click to expand...

9000 rows is a lot, I would have one sheet per month.

As a side benefit, using 3-D references you'll find it much easier to
make summaries across all months.
Click to expand...

Thanks to all,

I will consider the advantages of youir suggestions, and determine
which way to procede.

Thanks again,

Tonso
 
Back
Top