Alex has attended:
Excel Advanced course
Excel Advanced course
Circularity data table
Hi,
I have built a financial model with a couple of circular references and the model works just fine with iterative calculations. However, I would like to display the data in sensitivity tables but the calculation crashes (data table is working just fine since I can see that it's pulling the right figures) but it just automatically updates the circular reference part to wrong figures.
I have tried manual, automatic, automatic without table calcs and turning off circ switch as well.
I suspect it's because of heavy circular references but is there a way to tackle this?
Hope this is clear...Thank you!
RE: Circularity data table
Hi Alex,
Thank you for the forum question.
It is a very difficult question to answer without having a close look at the worksheet.
Please send the the workbook to:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector