Excel 2007, macro-enabled workbook (.xlsm) - only 65536 rows

S

supersharpshooter

New member
Joined
Jun 18, 2026
Messages
0
Reaction score
0
I have an excel macro-enabled workbook that’s running out of rows. For some reason it is only showing 65536 rows. Is there an option to enable the full million? I thought xlsm was a 2007 file format. Thanks.
 
Now that I took another look, it’s only one worksheet out of 20+ in the workbook that has 65536 rows. The rest of them have 1M+. How can I enable the full set of rows for this worksheet? Thanks.
 
Did you link in data from a .mdb, or is it just a plain tab right now?
 
is it being opened in compatibility mode? if so, open the spreadsheet - save it as the Excel 2007 format (Using Save As) and then open the new sheet.
 
I didn’t link any data to a database, I’ve basically been appending (pasting) data to a list for the past few months and now I’m at the bottom of the worksheet.
Thanks cpk, I don’t think it’s being opened in compatibility mode. My issue with saving as .xlsx is that it will lose the macros therefore I am saving it as .xlsm :-
Worst case scenario I’ll create a new worksheet and put the data in there, but I would like to avoid doing that because that will require changing all the references in the workbook to the new sheet :-s
 
If you save it as .xlsx it will still have the macros you you’ll just have to ensble macros to run them.
 
I think if you pull a tab from a .xls file into a .xlsx (or .xlsm) file, it will still have the smaller number of rows/columns. Unfortunately, the only way I know of to get around this is to copy the data into a new tab that was born in .xlsx/m.
 
thanks for the advice everyone, unfortunately i couldn’t get it to work. i ended up creating a new worksheet, copying over the data and changing all the references in the workbook.
 
You must log in or register to reply here.
Back
Top