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?
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.
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?