Perhaps one of the most useful STATA commands out there…

Working with wage and hour data and employment data, like we do on a daily basis involves the analysis of very large data sets.  Big data and employment data are often one in the same.  STATA has a very useful command that allows you to load in large Excel 2007/2010 spreadsheet files.  It is:

set excelxlsxlargefile on

This simple command allows the user to bypass the pre-set limit on spreadsheet size.

Just remember, STATA and your computer will be unresponsive during the load.  So be patient and let it all load up.