Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking Link to a Circular Reference with Macro
Hello,
I am building a large leverage model in Excel and I am running into long iteration times. The issue is this: I have Unlevered Total Costs and the Interest Costs and Loan Fees that equal a New Total Cost. This New Total Cost gets put back into the model, and is the number that Interest and Fees are based off of, therefore changing the Interest Costs and Loan Fees, which therefore changes the New Total Cost, etc...etc... When I break the link and input the new total cost manually, it works fine, however to get my New Total Cost cell to equal the Unlevered Total Cost + Interest and Fee, I have to manually do the iteration 5-7 times. I was hoping for some input on how to solve this problem. My idea has been to write a macro that will calculate the New Total Cost outside the model,(dependent calculations) convert it to text, and then link that cell to into model to then calculate through. I would then have a button that one could just press a few times to calculate it through. However, the macro I recorded seems to delete some of my formulas in the model, or gives me error messages. My skills at writing macros pretty much ends with the record button. Any help on this or any other suggestions to reduce iteration time would be greatly appreciated! Thank you for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating link to database w/o breaking the link | Excel Programming | |||
Breaking a link. | Excel Programming | |||
breaking a link | Excel Programming | |||
Macro avoiding circular reference | Excel Worksheet Functions | |||
Breaking the link | New Users to Excel |