Excel menu question
Moderator: Moderators
-
Mooncat
- Senior Member
- Posts: 11466
- Joined: Sun Dec 23, 2007 4:11 pm
- Location: Wales
- Has thanked: 81 times
- Been thanked: 72 times
Excel menu question
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?
I started out with nothing, I still have most of it.
Directmail scam information site: http://astrocat.proboards.com/index.cgi?
Directmail scam information site: http://astrocat.proboards.com/index.cgi?
-
Simon Site Manager
- Senior Member
- Posts: 3399
- Joined: Tue Oct 27, 2009 8:55 pm
- Location: St Helens Merseyside
- Has thanked: 48 times
- Been thanked: 202 times
Re: Excel menu question
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
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
Measure twice, cut once!