Import too large an Excel file into Stata

If you get the “file too big” error when using the “import excel using…” command in Stata, simply add

set excelxlsxlargefile on

To the top of your do file.  Stata will be unresponsive for any large excel file loaded, so be prepared.