Is it possible to see more than 65536 rows in Excel 2007? [closed]

by

Here is an interesting blog entry about numbers / limitations of Excel 2007. According to the author the new limit is approximately one million rows.

Sounds like you have a pre-Excel 2007 workbook open in Excel 2007 in compatibility mode (look in the title bar and see if it says compatibility mode). If so, the workbook has 65,536 rows, not 1,048,576. You can save the workbook as an Excel workbook which will be in Excel 2007 format, close the workbook and re-open it.

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  3. Function to convert column number to letter?
  4. Read/Parse text file line by line in VBA
  5. How do I find the last column with data?
  6. Better way to find last used row
  7. Excel VBA: Answer gets “stuck”
  8. 2 Dimensional array from range [closed]
  9. filter out multiple criteria using excel vba
  10. Excel VBA autofilter all but three
  11. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  12. Generating CSV file for Excel, how to have a newline inside a value
  13. Dir() function not working in Mac Excel 2011 VBA
  14. Excel VBA code to copy a specific string to clipboard
  15. Excel VBA – Range.Copy transpose paste
  16. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  17. How do you get a Range to return its Name?
  18. Excel VBA: Convert a date string to a Unix timestamp
  19. What does — do in Excel formulas?
  20. Insert picture into Excel cell [closed]
  21. Excel Formula to SUMIF date falls in particular month
  22. In Excel, can I use a hyperlink to run vba macro?
  23. Excel VBA – exit for loop
  24. Can I export excel data with UTF-8 without BOM?
  25. Extract the last substring from a cell
  26. Best way to protect Excel VBA code? [closed]
  27. Why does Excel not round according to 8-byte IEEE 754
  28. VBA: Remove duplicates fails when columns array is passed using a variable
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment