how do I open a new spreadsheet that is not in compatability mode. I need to
import data that has more rows than the 65xxx allowed by earlier versions.
Open your workbook in Excel 2007 (compatibility mode), then use Save As to
save a copy of it in Excel 2007 format. Close the workbook. Open the new
..xlsx (or .xlsm if it has macros) file and it will have the extra rows you
need available.
If you're importing from a .csv/.txt file you may find this file handy - it
is an Excel 2003 format file that permits importing more than 64K rows of
data by importing the excess rows to additional sheets: http://www.jlathamsite.com/uploads/ImportExcessRowsOfData_R1.xls
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
