none
Excel 2010 Maximum Rows

    Question

  • 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?

    Thanks,

    Sadegh

    Saturday, January 21, 2012 9:45 PM

Answers

  • 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.

     

     

    Sincerely

    Rex Zhang


    Rex Zhang

    TechNet Community Support

    Monday, January 23, 2012 3:46 AM
    Moderator