Hi all,
I have a pretty large portfolio loan amortization model I built. It's 45MB right now. I have a few issues I have been running into.
1- I utilized the error checking and i do not have any circular references but the model won't refresh unless I enable iterative calculations.
Any thoughts on this?
2- The model is huge , when I do run the iterations I have to wait till 200-300 iterations. Sometimes longer. Is there a way to clean it up and make it faster?
3- This model has too many stressed scenarios in my losses assumptions and I think I am using lots of memory. Whenever I make changes to logic and rerun the file breaks.
To give you an example it broke on my when i changes a formula, but i did not input a wrong formula, I did not mess up a refernce or anything.
After I pasted values for some tables i had that were TRANSPOSE formulas ,the file worked and ran the iterations.
Now i changed the same formula and just added 2 cells and it broke and won't run.
I ran out of ideas and don't know what to look for. Any ideas?
I have a pretty large portfolio loan amortization model I built. It's 45MB right now. I have a few issues I have been running into.
1- I utilized the error checking and i do not have any circular references but the model won't refresh unless I enable iterative calculations.
Any thoughts on this?
2- The model is huge , when I do run the iterations I have to wait till 200-300 iterations. Sometimes longer. Is there a way to clean it up and make it faster?
3- This model has too many stressed scenarios in my losses assumptions and I think I am using lots of memory. Whenever I make changes to logic and rerun the file breaks.
To give you an example it broke on my when i changes a formula, but i did not input a wrong formula, I did not mess up a refernce or anything.
After I pasted values for some tables i had that were TRANSPOSE formulas ,the file worked and ran the iterations.
Now i changed the same formula and just added 2 cells and it broke and won't run.
I ran out of ideas and don't know what to look for. Any ideas?
