www.ultimatehandyman.co.uk

I downloaded an Excel 97/2003 spreadsheet which contains circular references, and I found websites explaining how to turn Iteration on. But I'm using Excel 2007, and the menus are completely different. There is no Tools >Options > Calculation that I can see. How do I allow Iteration?

Hi Moony,

Click the Microsoft button with Excel open, click Excel Options, click Formulas, click Calculation Options, click 'Enable Iterative Calculations'

That should do it.

S

-- Mon Aug 09, 2010 5:20 pm --

Don't mention it Mooncat, Oh! you didn't!

S