Error with number of variables to export excel - STATA 13

[qocande]

Hello,

My dataset has 524 variables. I wanted to export all variables to Excel. However, I was not able to export it and the error message was "too many or no variables specified". I used drop down options to export (i.e., File> Export>Data to Excel spreadsheet). I left the "variables" box empty as recommended for exporting all variables and I checked the "save variable names to first row in Excel file".

I am using Stata/IC 13 which, as indicated by STATA, has features of max no. of variables (2047) and max no. of right hand variables (798).

If you know what is wrong or why I cannot export all variables of my dataset to Excel, pleas advise.

Thanks

Quynh

[Roberto Ferrer]

Make sure you are saving to an .xlsx file and not an .xls file. The latter has a limit of 256 columns in which to place variables.

Use something like: D:\somedir\test550vars.xlsx in the "Excel filename" textbox.

[qocande]

Thanks Roberto for the advice as well as the reminders. It worked for me.