Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

circularity data table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Circularity data table

Circularity data table

ResolvedVersion 365

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

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.