Why can I not open large files in Excel? What is the maximum limit to be able to open a file in Excel?

If you open a very large file in Excel it might not open up fully. For instance, I tried opening up a .csv file of 480MB and which had 2.2M records it would not open up completely. The reason is Excel has a limit of 1,048.576 rows and 16, 384 columns it can have in a file.  


So if you  try to open up a file with 2.2 Million records, it will open the file but will display only 1,048.576 records.


Here is the Error Info that Microsoft gives on opening very large files.


Excel cannot exceed the limit of 1,048,576 rows and 16,384 columns