Excel Import Crash

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Excel Import Crash

Postby fmantessof » Fri Aug 14, 2015 8:05 am

Hi, I am having constant crashes when importing data from Excel 2013 into Eviews9. After selecting the excel file, it opens the data and when clicking next in the first screen it crashes and closes. Could somebody help please ?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13316
Joined: Tue Sep 16, 2008 5:38 pm

Re: Excel Import Crash

Postby EViews Gareth » Fri Aug 14, 2015 8:07 am

A specific Excel file, or any Excel file?
Follow us on Twitter @IHSEViews

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Excel Import Crash

Postby fmantessof » Fri Aug 14, 2015 8:24 am

Any excel file

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13316
Joined: Tue Sep 16, 2008 5:38 pm

Re: Excel Import Crash

Postby EViews Gareth » Fri Aug 14, 2015 8:26 am

What is the build date of your copy of EV9? (Help->About EViews)
Follow us on Twitter @IHSEViews

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Excel Import Crash

Postby fmantessof » Fri Aug 14, 2015 8:34 am

28 Jul 2015

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Excel Import Crash

Postby EViews Jason » Fri Aug 14, 2015 9:43 am

How are you opening the excel file within EViews? Are you dragging and dropping the file or are you using file->open->foreign data as workfile?

Are you using the 32 or 64 bit version of EViews? (type supportinfo and enter into the EViews command window)

Do you have Excel open during this process? If yes, try shutting down Excel and then try importing the Excel file. Does the crash go away?

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Excel Import Crash

Postby fmantessof » Fri Aug 14, 2015 10:01 am

How are you opening the excel file within EViews? Are you dragging and dropping the file or are you using file->open->foreign data as workfile? - OPEN FOREIGN DATA AS WORKFILE

Are you using the 32 or 64 bit version of EViews? (type supportinfo and enter into the EViews command window) - 64BIT

Do you have Excel open during this process? If yes, try shutting down Excel and then try importing the Excel file. Does the crash go away?, - TRIED WITH IT OPEN AND CLOSED, BOTH CRASHES

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Excel Import Crash

Postby EViews Jason » Fri Aug 14, 2015 10:46 am

Are you having problems opening xls or xlsx or both files?

You said previously, all Excel files are causing the crash? Can you try with a small file (less than 2 MBS)? Did that crash?

From EViews, select options->general options. In the left pane, select file locations. Click the folder button next the Temp File Path box. Does that path exist? What is that path? Roughly how many files are in that directory? Remove all files in that directory and try again.

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Excel Import Crash

Postby fmantessof » Fri Aug 14, 2015 11:43 am

is there any issue with Eviews9 64 bit and Excel 2013 32bit ? Or I need to have Excel 64 bit ?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13316
Joined: Tue Sep 16, 2008 5:38 pm

Re: Excel Import Crash

Postby EViews Gareth » Fri Aug 14, 2015 11:44 am

No issue.
Follow us on Twitter @IHSEViews

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Excel Import Crash

Postby fmantessof » Fri Aug 14, 2015 11:51 am

Which one function better if I were to choose from ? I will try o install everything and install everything again (Office and Eviews)

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13316
Joined: Tue Sep 16, 2008 5:38 pm

Re: Excel Import Crash

Postby EViews Gareth » Fri Aug 14, 2015 12:31 pm

Answering Jason's questions will help us diagnose
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: Google [Bot] and 9 guests