How to increase number of rows in excel sheet?

[Tim Orszula]

I have a need to increase the number of rows past the 1 million limit in Excel.  What are my options?

[#2]

Hi Tim,

No way, you can't expand Excel sheet limits. On the other hand you may load your data into data model and process them using Power View returning compact result into Excel sheet. Here are formal limits as well, but practically it's limited only by your memory size.

[#3]

just thinking out loud:
if your row will be 100 columns -
you will have more than 170 million "rows" per worksheet at your disposal....