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.