EViews.com

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

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

You can use: to revert to the old method (which uses Excel itself to do the save).

Thanks so much!

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 "

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