Excel 100% sometimes

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a spreadsheet that has 10 columns which carry formulas such as:

IF(ISBLANK(A2)=FALSE,IF(A2>B2,C2,IF(A2<B2,D2,IF(ISNUMBER(Q2),Q2,""))),"")

The columns are populated from Row 1 to the last one (60 thousand and
some). The problem that I running into is that sometimes the values
are updated at the speed of light and that is all great (less than 1
second or 2), but sometimes the spreadsheet just sits there for
minutes (actually I have not yet been patient enough to see if it ever
comes back - but the app is locked, I can't stop it and I can only
kill it through the task manager).

Why does Excel sometimes acts as if the cells were cached and hence
I assume the speed on updating the spreadsheet formulas
(recalculating) and sometimes it just sits there at 100% and nothing
happens - the app freezes, I can get foucs nor interrupt whatever it
is doing. Is there a way to put Excel in debug mode so at least I can
see that it is doing some work and it is not just a BUG in Excel's
code where there might be a runaway thread which eventually never
returns some sort of handler back.

Or better yet, any ideas how I could fix this problem?

Thank you
 
I would imagine your file size would be quite large with
that formula in 10 columns and 65536 rows. It may be
more efficient if you use some VBA code instead of the
formulas. Or use Access to store the data and generate
your desired results.
 
Back
Top