@keep issue after uprgrading to Eviews 13

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

dgrypma
Posts: 4
Joined: Tue Mar 21, 2023 9:12 am

@keep issue after uprgrading to Eviews 13

Postby dgrypma » Tue Mar 21, 2023 3:01 pm

I am receiving this error:

" Unable to allocate memory for working array in "PAGESAVE
(TYPE="EXCELXML",MODE=UPDATE) "C:\DATA\EVIEWSTESTING
\PEAP\EXCELPEAP\EXCELPEAP.XLSX" RANGE="SOURCES!B1"
@KEEP S311022F" in EXCELPEAP.PRG on line 160."

and it happens kind of randomly in my program for lines of code such as

pagesave(type="excelxml",mode=update) {%y}\PEAPVars.xlsx range="Decisions_Input!a5" @keep @date mnemonics

pagesave(type="excelxml",mode=update) %excelfilename range="current_forecast!a1" @keep @date mnemonics

the main issue is that I did not run into this issue when running this code on eviews 12

wondering if there is a memory setting or workaround to avoid this

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

Re: @keep issue after uprgrading to Eviews 13

Postby EViews Gareth » Tue Mar 21, 2023 3:09 pm

We switched to a "better" open source library for saving Excel files in EViews 13. It seems to have some issues.

You can use:

Code: Select all

pagesave(type="excelxml",mode=update, legacy) {%y}\PEAPVars.xlsx range="Decisions_Input!a5" @keep @date mnemonics

to revert to the old method (which uses Excel itself to do the save).
Follow us on Twitter @IHSEViews

dgrypma
Posts: 4
Joined: Tue Mar 21, 2023 9:12 am

Re: @keep issue after uprgrading to Eviews 13

Postby dgrypma » Tue Mar 21, 2023 3:38 pm

Thanks so much!

dgrypma
Posts: 4
Joined: Tue Mar 21, 2023 9:12 am

Re: @keep issue after uprgrading to Eviews 13

Postby dgrypma » Fri Mar 31, 2023 11:09 am

EViews Gareth wrote:We switched to a "better" open source library for saving Excel files in EViews 13. It seems to have some issues.

You can use:

Code: Select all

pagesave(type="excelxml",mode=update, legacy) {%y}\PEAPVars.xlsx range="Decisions_Input!a5" @keep @date mnemonics

to revert to the old method (which uses Excel itself to do the save).



I am actually still running into the same error, even after incorporating " , legacy "

dgrypma
Posts: 4
Joined: Tue Mar 21, 2023 9:12 am

Re: @keep issue after uprgrading to Eviews 13

Postby dgrypma » Mon May 01, 2023 9:47 am

Hello, just wanted to flag that adding in the argument ' ,legacy' has not resolved this issue


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 20 guests