Page 1 of 1

Eviews 12 pagesave to excel crash

Posted: Tue Dec 21, 2021 3:11 pm
by eviews_5
Hi,

I've been having a problem with the pagesave command in Eviews 12. I'm using the pagesave command to update excel sheets in two different programs . Eviews crashes every time both of the programs hit the pagesave command. When I create new excel files instead of updating an old one the programs work fine, and both of these programs work fine on my colleagues computer. I was hoping for some suggestions.

Here is my command:
pagesave(t=excelxml, mode=update) "U:\2022_01\figures\data\data_underlying_figures.xlsx" range={%figname} @keep qgdp_pc qgdpfe_pc @smpl {%firsthist} {%lastsim}

Re: Eviews 12 pagesave to excel crash

Posted: Tue Dec 21, 2021 4:05 pm
by EViews Gareth
Currently, EViews uses Excel itself to update the file. i.e. it opens Excel (or if Excel is already open, it uses the already open Excel), passes over the data to Excel and then tells Excel to save the file.

If there is any sort of issue with Excel (isn't installed properly, is currently non-responsive, is currently waiting for user input etc...) it can cause the process to crash.

Re: Eviews 12 pagesave to excel crash

Posted: Thu Dec 23, 2021 8:51 am
by eviews_5
Thanks! There was something wrong with Excel. My programs work now.

Re: Eviews 12 pagesave to excel crash

Posted: Thu Dec 23, 2021 9:57 am
by EViews Gareth
We're hoping to move away from this system in EV13 so that issues with Excel don't cascade.