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

[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

 

[isabelle]

hi Tonso,

if you have "Access", you can put data into an Access table and analyze it with Excel

 

[Stan Brown]

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?

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.

 

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

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.

Thanks to all,

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

Thanks again,

Tonso