Usually I have been able to calculate a scenario, and the results save, including anything pulled from excel sheets. Since the latest update my model wants to re-calculate everything every time I change something. This is making it impossible to work with as my model is very large and each of my scenarios take a long time to calculate. For example - I run results for my reference scenario - it calculates - I save - I make a change in an alternate scenario run results - to calculates the reference scenario all over again before going to the alternate scenario calculations (perhaps an issue with storing the excel cache?). There is also an issue where it gives an error when trying to calculate results (image attached). This error is fixed if I close excel from the task manager and re-calculate, but then it re-calculates the entire area and all scenarios.

Edit: Feb 21, 2017

An addendum to my original posted comments:

This issue does not happen when I work with previous saved versions of my area, so it does not seem to be an issue with the LEAP Version, rather something with my LEAP area. It is as though it will not save an excel cache. For the area having issues I copied and renamed the original area file to keep one as a back up file. Perhaps this can cause these issues? Not a pressing issue but any insights are appreciated.

Thank you,

Matt

I'm really not able to reproduce this on my computer with LEAP 2017.0.5.0. I've tried using a simple two-region model with several scenarios, and which has an expression referring to a value stored in an external Excel document using the Excel() function, as you have. I can verify that if I change a value in one of the scenarios and regions on which no other scenarios and regions depend, only that scenario is recalculated when I return to the Results view.

Some follow up questions:

Best,

Taylor

Hi Taylor,

To answer your questions:

2.
Are the referenced Excel documents already open on your desktop when you calculate results?

• They are typically not, however, generally, it has not mattered if a referenced excel document was open or closed, the model would calculate without error.

Does the problem occur if you preemptively open each of these referenced documents?

• It does occur still. Also, I just found that I can not open the documents after the error has occurred. Once I force close excel from the task manager or save LEAP, then run results, the entire area will re-calcualte once again, even though it may have just calculated.

Sorry for the problems and frustrations this is causing.

I had a look at the data set you sent. Its too big to easily debug but I tried setting the end year down to 2020 and reducing the number of regions calculated. At that point I cannot reproduce the issue. I suspect though that there may be an issue with the caching of all the Excel files you reference You may want to try exiting LEAP then deleting the file "ExcelCache.ini" in you LEAP area and then try again. Suggest you test this out with a small number of years and small number of regions and then gradually step up the size of the problem to see if the problem goes away or still occurs. Meantime, I will do a bit more testing now.

Best,

Charlie

LEAP developer