Life beyond Row 65536???

[raven_squire]

Hello,

I blieve that I am using excel 2010 and I want to go off the edge of the spread sheet.

I have a macro that interpolates a list of data that is 16223 rows long. The macro makes it aproximatily 5 times longer so aproximatly 82000 rows, but my spread sheet only goes up to 65536 and the macro fails. I can think of some work arounds but I was wondering if excel can go beyond row 65536 somehow??


Thanks

 

[Fluff]

It sounds as if your workbook is an .xls file
If you save it as an xlsm file, close & reopen. Then you can goto 1048576 rows

 

[steve the fish]

Excel has had over a million rows from excel 2007. If you need more rows then you need to use another sheet.

 

[Scott T]

You would have to move some data to a different sheet if you exceed the max number of rows.

 

[Dryver14]

Its probably the macro that's stopping it have a look at the code and anywhere it mentions 65536 change it to 1048576 so it stretches all the way down.

If you only have that many rows it may be an .xls file from 2003

try save as xlsx

 

[raven_squire]

Ahh that makes sense. The workbook I am working from came from the internet and is an older excel format. I am not sure specifically what format but I have had warning messages when attempting to save it. I kept working from that workbook as I am using someone elses work and I don’t understand it all. I will try save it as an XLSM
Thanks

 

[Joe4]

I will try save it as an XLSM

I wouldn't save it as an "XLSM" unless it has VBA code in it.
If it doesn't, save it as an "XLSX" (which is a Macro-free workbook). That will cause less potential issues (warnings about security concerns, etc).