Help!! Excel keeping Calculating

**redskinp** · 10-12-2006, 03:56 PM

I have built a monster budget file for my company. It has array functions, vlookups, hlookups, sumif's, etc. It's a very large file now(10 megs) and every time I do anything in the worksheets, excel tries to calculate. It takes a while...at the bottom it reads 'calculating 5%,10%,15%....100%', which I know it is supposed to do, but when it is done, the word 'calculate' is still there on the bottom left of the screen. It's like even though it says it was done calculating, it still needs to calculate again. I'm not sure what the problem is. Can someone help me. Everytime I do anything, even if it is just formatting ie - making a column wider, it's tries to recalculate. I've tried F9 and Shift+F9, but that 'calculate' never goes away

What could this be? Is it something excel is trying to run through formulas in a certain order. Many of my sheets are dependent on other ones, so maybe that's the issue. Any help would be greatly appreciated.

Thanks,
Scott

PS - I am using MS Excell 2003 on Windows XP

**abrazee** · 10-12-2006, 04:11 PM

you sound like an advanced user so just a shot in the dark -
have you tried to set the Iteration to one on the calculation tab in options?
do you have some left over remote reference? (On edit look a links)

**redskinp** · 10-12-2006, 04:39 PM

I changes the iteration to 1 and I actually broke all my links and deleted sheets that link to external files, but it still didn't work. Is there anything else you could recommend. Do you what it means when the 'calculate' is still there.

Also, I don't know what you meant by remote references? where you just referring to my links?

Thanks,
Scott

**abrazee** · 10-12-2006, 04:54 PM

Sometimes if formulas are copied links are created. It is a reference to another file that isn't needed, but excel wants to go get it. On the edit tab is links. If you have none it will be grayed out. If you have any check them out and delete them if they arn't needed.

I have never seen the calculate problem.

Turn off automatic calculation in the calculation tab. If you need to calculate hit F9

Work?