Excel 2010 Maximum Rows


  • Hi,


    I am gathering data for an experiment but unfortunately, excel only has a maximum 1,048,576 rows available. I installed Powerpivot but it didn't increase the maximum allowable rows.

    Is there any way I can do this?



    Saturday, January 21, 2012 9:45 PM


  • Hi,


    Thank you for using Microsoft Office for IT Professionals Forums.


    Form your description, you have reached the Worksheet size limit of Excel.


    To work around this, I would suggest to import data into a database created by Microsoft Access which can contain about 2 gigabytes data.


    If there is any misunderstanding, please feel free to let me know.


    Thanks for your understanding.




    Rex Zhang

    Rex Zhang

    TechNet Community Support

    Monday, January 23, 2012 3:46 AM