Page 1 of 1

Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 12:11 pm
by BT454
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

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 12:32 pm
by startz
A quick thing to try is to update your copy of EViews.

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 12:33 pm
by BT454
I wish I could, but it that option has been "disabled by my administrator"

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 12:42 pm
by EViews Gareth
Updating is the only solution. Speak to your administrator.

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 1:40 pm
by BT454
I reinstalled 11, and updated manually using the patch posted on the eviews website for eviews11x64, and pagesave is still crashing...

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 2:58 pm
by EViews Gareth
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.

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 3:00 pm
by BT454
I have rebooted, and tried with excel closed. Still crashes. I will try it again.

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 3:03 pm
by EViews Gareth
Might be something funky with the existing Excel file.

Re: Eviews crashing during pagesave to excel

Posted: Fri Nov 20, 2020 3:04 pm
by startz
Following on what Gareth says, try opening the Excel file and saving it under another name and then try with the new file.