Troubles importing open Excel file

[George Ford]

Anyone having trouble importing Excel file into Stata while the excel file is open? After latest Office update, I can no longer import open files, which I could do before.

[Phil Bromiley]

I have the same problem in Windows 10. I don't know if it worked on my machine in the past. You might contact Stata tech support.

[Joseph Coveney]

Same here (Windows 10), and likewise I don't recall whether I could do it in the past.

While you're waiting for Stata technical support to reply, here's a workaround (I manually opened the Excel workbook at the drop _all line):

.ÿsysuseÿauto
(1978ÿAutomobileÿData)

.ÿexportÿexcelÿusingÿF:\Autos.xlsx,ÿsheet(Autos)ÿfirstrow(variables)
fileÿF:\Autos.xlsxÿsaved

.ÿdropÿ_all

.ÿimportÿexcelÿusingÿF:\Autos.xlsx,ÿsheet(Autos)ÿfirstrow
fileÿF:/Autos.xlsxÿcouldÿnotÿbeÿloaded
r(603);

.ÿtempfileÿtmpfil0

.ÿcopyÿF:\Autos.xlsxÿ`tmpfil0'

.ÿimportÿexcelÿusingÿ`tmpfil0',ÿsheet(Autos)ÿfirstrow

.ÿeraseÿ`tmpfil0'

.

[George Ford]

Clever

[George Ford]

This problem seems to have been resolved in an update.