Auto Calculate

Giganews Newsgroups
Subject: Auto Calculate
Posted by:  Randy S
Date: Thu, 25 May 2006

I have a large spreadsheet (50 MB) with lots of formulas. I have
auto-calculations turned off, and just manually recalculate as I need to
(because it takes so long). When I do calculate (F9), the Calculate indicator
at the bottom left status bar stays on even after calculating. I hit F9
again, it calculates, I hit F9 again, it calculates, etc

My question is: is there any way of identifying what is causing this to
occur? How can I get it to calculate once and be done like all my other
(smaller) spreadsheets?

Replies