Re: Opening excel file

Posted by Andrew Rudd on Aug 18, 2009; 9:49pm
URL: http://spssx-discussion.165.s1.nabble.com/Opening-excel-file-tp1090158p1090160.html

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

Andrew

>>> SPSS Support <[hidden email]> 19/08/2009 3:47 a.m. >>>

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 Subject:  Error starting the Java Virtual Machine, unable to open file: <filename>

Problem Description:  I am trying to import files from Excel 2007 and I get the following error:

Error starting the Java Virtual Machine, unable to open file: <filename>

Can SPSS 16.0 import files from MS Excel 2007?

Resolution Subject: This problem will been corrected in SPSS Statistics 17.0.1. We apologize for any inconvenience.

Resolution Description: 
The file is most likely in *.xlsm format and thus contains macros.

The current workaround is to save the file to a non-macro enabled file (*.xlsx), then you will be able open the file.

This problem has been mostly corrected in SPSS Statistics 17.0. One aspect of the macro-enabled .xlsm was overlooked but will be corrected in SPSS Statistics 17.0.1. We apologize for any inconvenience.

 

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jamison, Cheryl S
Sent: Tuesday, August 18, 2009 8:24 AM
To: [hidden email]
Subject: 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

 

 

--
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.

P Please Consider the Environment before Printing this e-mail

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.