"Error accessing the excel file. If the file is open in another application".......

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

joshman108
Posts: 2
Joined: Wed Dec 02, 2015 6:24 pm

"Error accessing the excel file. If the file is open in another application".......

Postby joshman108 » Wed Dec 02, 2015 6:31 pm

"Error accessing the Excel file. If the file is open in another application, please close it and retry."

I am running spss 21 and have a .xlsx file that I downloaded from google sheets. Somehow I feel like that's the problem.. but I'm not sure. I have searched and found that others had this problem but none of their advice worked for me. Changing the title didn't work, restarting didn't work, setting character encoding to "unicode" didn't work - it was already there as a default, closing excel processes didn't work because I don't even have excel on my computer.

I can download as .csv data but that is a complete pain in the keister.

Let me know if I'm forgetting to provide any information.
GerineL
Moderator
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: "Error accessing the excel file. If the file is open in another application".......

Postby GerineL » Fri Dec 04, 2015 11:08 am

so you have had the file open in excel and saved it to your computer? what about saving as cvs in excel?

Who is online

Users browsing this forum: No registered users and 2 guests

cron