Problems on Exporting to Excel

[Laura Elizabeth]

Hello,
I am trying to save my data into an Excel file but am having difficulty doing so.

I have received the following error messages. I made sure to not have any Excel worksheets open.

. export excel using "duplicatesYearAddress", firstrow(variables)
file duplicatesYearAddress.xls already exists
r(602);

. export excel using "duplicatesYearAddress", firstrow(variables) replace
file duplicatesYearAddress.xls could not be saved
r(603);

From what I've read elsewhere, the problem might be linked to the location where stata is saving. Previous successful exports went to the desktop no problem.
Thanks very much in advance!

[William Lisowski]

Stata is attempting to save the workbook into your current directory. The pwd command will tell you what that directory is, and the dir command will tell you what files already exist in that directory.

If you change the name of the workbook you are saving to something that doers not already exist, can it be saved? If not, it appears you do not have permission to write in your current directory. If so, perhaps the duplicateYearAddress file has been made read only, so it cannot be replaced.