Eviews crashing during pagesave to excel

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

BT454
Posts: 135
Joined: Wed Aug 02, 2017 6:07 am

Eviews crashing during pagesave to excel

Postby BT454 » Fri Nov 20, 2020 12:11 pm

Hi all,
I upgraded eviews to eviews11, and since then it is crashing when attempting to pagesave to excel (if excel is closes, eviews closes abruptly. If excel is open, I receive the following error)
Unable to load Microsoft Excel automation library in
"PAGESAVE(T=EXCEL, MODE=UPDATE, ATTR) C:\WAREM32
\MMR_ST_PGCR.XLSX RANGE="TABLE3 USBALANCESMONTHL
Y!A6" @FREQ M 2005 "2023" @KEEP SPRODUS SLNGSOUS
SCANIMPUS STUS DRESUS DCOMUS DINDUS DPOWUS
DVEHUS DPLPFUS DDTUS DNMXEXUS DLNGEXUS DTEXUS
DTUS UAUS NIWUS INVUS".

I'm using eviews version April 5 2019 build
I've attached the .prg, workfile, and log file. I have also tried using eviews10 and receive the same error.
This job is used for client facing production, and is time sensitive. I greatly appreciate your help.
Thanks!
Bob
Attachments
log.txt
(2.02 KiB) Downloaded 208 times
mmrdata_st_pgcr.prg
(26.1 KiB) Downloaded 219 times
mmrdata.wf1
(2.49 MiB) Downloaded 197 times

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: Eviews crashing during pagesave to excel

Postby startz » Fri Nov 20, 2020 12:32 pm

A quick thing to try is to update your copy of EViews.

BT454
Posts: 135
Joined: Wed Aug 02, 2017 6:07 am

Re: Eviews crashing during pagesave to excel

Postby BT454 » Fri Nov 20, 2020 12:33 pm

I wish I could, but it that option has been "disabled by my administrator"

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

Re: Eviews crashing during pagesave to excel

Postby EViews Gareth » Fri Nov 20, 2020 12:42 pm

Updating is the only solution. Speak to your administrator.
Follow us on Twitter @IHSEViews

BT454
Posts: 135
Joined: Wed Aug 02, 2017 6:07 am

Re: Eviews crashing during pagesave to excel

Postby BT454 » Fri Nov 20, 2020 1:40 pm

I reinstalled 11, and updated manually using the patch posted on the eviews website for eviews11x64, and pagesave is still crashing...

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

Re: Eviews crashing during pagesave to excel

Postby EViews Gareth » Fri Nov 20, 2020 2:58 pm

Looks like you're doing an update to the Excel file. This can cause a crash if Excel is in a funny mood. Try rebooting and not having Excel open.
Follow us on Twitter @IHSEViews

BT454
Posts: 135
Joined: Wed Aug 02, 2017 6:07 am

Re: Eviews crashing during pagesave to excel

Postby BT454 » Fri Nov 20, 2020 3:00 pm

I have rebooted, and tried with excel closed. Still crashes. I will try it again.

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

Re: Eviews crashing during pagesave to excel

Postby EViews Gareth » Fri Nov 20, 2020 3:03 pm

Might be something funky with the existing Excel file.
Follow us on Twitter @IHSEViews

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: Eviews crashing during pagesave to excel

Postby startz » Fri Nov 20, 2020 3:04 pm

Following on what Gareth says, try opening the Excel file and saving it under another name and then try with the new file.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 23 guests