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
Eviews crashing during pagesave to excel
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
Eviews crashing during pagesave to excel
- Attachments
-
- log.txt
- (2.02 KiB) Downloaded 209 times
-
- mmrdata_st_pgcr.prg
- (26.1 KiB) Downloaded 219 times
-
- mmrdata.wf1
- (2.49 MiB) Downloaded 197 times
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Eviews crashing during pagesave to excel
A quick thing to try is to update your copy of EViews.
Re: Eviews crashing during pagesave to excel
I wish I could, but it that option has been "disabled by my administrator"
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Eviews crashing during pagesave to excel
Updating is the only solution. Speak to your administrator.
Follow us on Twitter @IHSEViews
Re: Eviews crashing during pagesave to excel
I reinstalled 11, and updated manually using the patch posted on the eviews website for eviews11x64, and pagesave is still crashing...
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Eviews crashing during pagesave to excel
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
Re: Eviews crashing during pagesave to excel
I have rebooted, and tried with excel closed. Still crashes. I will try it again.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Eviews crashing during pagesave to excel
Might be something funky with the existing Excel file.
Follow us on Twitter @IHSEViews
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Eviews crashing during pagesave to excel
Following on what Gareth says, try opening the Excel file and saving it under another name and then try with the new file.
Who is online
Users browsing this forum: No registered users and 29 guests