Locked
P Please Consider the Environment before Printing this e-mail
Opening excel file
 
|
Hi List— I am using SPSS V17 for the first time, and am trying to open
an .xlsx excel file (which should be ok). I get the following error: “Error
starting the virtual Java machine, unable to open file..” (and it gives
the filename). Does anyone have any suggestions? I tried saving it as an
older Excel file, but that didn’t help. Thanks— Cher |
|
|
Two things:
Matthew Pirritano, Ph.D. Research Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (714) 568-5648 From: SPSSX(r)
Discussion [mailto:[hidden email]] On
Behalf Of Jamison, Cheryl S Hi
List—
I am using SPSS V17 for the first time, and am trying to open an .xlsx
excel file (which should be ok). I get the following error:
“Error starting the virtual Java machine, unable to open file..”
(and it gives the filename). Does anyone have any
suggestions? I tried saving it as an older Excel file, but that
didn’t help.
Thanks—
|
|
|
In reply to this post by Jamison, Cheryl S
Hi Cheryl, Which exact version of Statistics
are you running? See Help->About to check. If it is 17.0 or 17.0.1, I’d
suggest first installing the 17.0.2 patch from http://support.spss.com
and then retrying to open the file. Which steps were you using to open the
file? (File->Open; File->Open Database, etc)? Also, which operating system and version are
you running? The error message you encountered was
reported in v 16, but should be fixed for .xlsx files (as opposed to .xlsm) in
17.0, as reported in the resolution below. David Matheson SPSS Statistical Support *********************** Resolution number: 79284 Created on: Aug 22 2008 Last Reviewed on: Aug 18 2009 Problem Description:
I am trying to import files from Excel 2007 and I get the following
error: Resolution Subject: This
problem will been corrected in SPSS Statistics 17.0.1. We apologize for any
inconvenience. Resolution Description: From: SPSSX(r)
Discussion [mailto:[hidden email]] On
Behalf Of Jamison, Cheryl S Hi
List—
I am using SPSS V17 for the first time, and am trying to open an .xlsx
excel file (which should be ok). I get the following error:
“Error starting the virtual Java machine, unable to open file..”
(and it gives the filename). Does anyone have any
suggestions? I tried saving it as an older Excel file, but that
didn’t help.
Thanks—
|
|
|
I'm getting the same error also, which is strange as I was able to open
a .xlsx the other day. It did work however when I saved it as a .xls file. (Using the File-->Open command) I'm running version 17.0.2, I'm just curious as to why one week it
worked and the next it doesn't... Does any one else have any other suggestions?
Thanks
Hi Cheryl, Which exact version of Statistics are you running? See Help->About to check. If it is 17.0 or 17.0.1, I’d suggest first installing the 17.0.2 patch from http://support.spss.com and then retrying to open the file. Which steps were you using to open the file? (File->Open; File->Open Database, etc)? Also, which operating system and version are you running? The error message you encountered was reported in v 16, but should be fixed for .xlsx files (as opposed to .xlsm) in 17.0, as reported in the resolution below. David Matheson SPSS Statistical Support *********************** Resolution number: 79284 Created on: Aug 22 2008 Last Reviewed on: Aug 18 2009 Problem Description: I am trying to import files from Excel 2007 and I get the following error: Resolution Subject: This problem will been corrected in SPSS Statistics 17.0.1. We apologize for any inconvenience. Resolution Description: From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jamison, Cheryl S Hi List— I am using SPSS V17 for the first time, and am trying to open an .xlsx excel file (which should be ok). I get the following error: “Error starting the virtual Java machine, unable to open file..” (and it gives the filename). Does anyone have any suggestions? I tried saving it as an older Excel file, but that didn’t help. Thanks— -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Unintended Recipient: This message (and/or any files transmitted with it) contains confidential and/or privileged information for use by the intended recipient. If you have received this message in error, we apologise and request that you immediately destroy all trace of this message and/or attached files and do not use, copy, disseminate or otherwise action. It would also be appreciated if you could notify the Help Desk on 0800 502 442. Disclaimer: Any views expressed in this message (or attached files) are those of the individual sender, except where the message clearly states otherwise and the sender is authorised to state them to be the views of the organisation. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. |
|
|
In reply to this post by Jamison, Cheryl S
hello i am Usind SPSS 17.0v making huge time delay in delivering the outputs. While exporting the information from SPSS to Excel we are getting error “Can’t recover contents”. Also, the format of information in Excel is not coming properly even after trying multiple times. |
|
|
In reply to this post by Jamison, Cheryl S
hello i am Usind SPSS 17.0v making huge time delay in delivering the outputs. While exporting the information from SPSS to Excel we are getting error “Can’t recover contents”. Also, the format of information in Excel is not coming properly even after trying multiple times. |
|
|
In reply to this post by Jamison, Cheryl S
hello i am Usind SPSS 17.0v making huge time delay in delivering the outputs. While exporting the information from SPSS to Excel we are getting error “Can’t recover contents”. Also, the format of information in Excel is not coming properly even after trying multiple times. |
|
|
In reply to this post by mpirritano
Thanks so much for this post. My issue was relating to password protected documents and this has saved me a great deal of time.
|
|
|
In reply to this post by mpirritano
I am using SPSS V17.0 , and am trying to open an .xlsx excel file. I get
the following error: “Error starting the virtual Java machine, unable to open file..” . Does anyone have any suggestions? -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
I have had the same problem, but that seemed to disappear when the Excel file first was opened and then resaved. This only has happened with Excel files exported from another system, so it seems to be more of an Excel problem than something realted to SPSS.
Robert -----Ursprungligt meddelande----- Från: SPSSX(r) Discussion [mailto:[hidden email]] För Saira2280 Skickat: den 4 maj 2021 22:15 Till: [hidden email] Ämne: Re: Opening excel file I am using SPSS V17.0 , and am trying to open an .xlsx excel file. I get the following error: “Error starting the virtual Java machine, unable to open file..” . Does anyone have any suggestions? -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Robert Lundqvist
|
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |