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
@keep issue after uprgrading to Eviews 13
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: @keep issue after uprgrading to Eviews 13
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).
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
Re: @keep issue after uprgrading to Eviews 13
Thanks so much!
Re: @keep issue after uprgrading to Eviews 13
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 "
Re: @keep issue after uprgrading to Eviews 13
Hello, just wanted to flag that adding in the argument ' ,legacy' has not resolved this issue
Who is online
Users browsing this forum: No registered users and 7 guests