Calculation in Excel 2000 hangs processor.

  • Thread starter Thread starter Podger
  • Start date Start date
P

Podger

My spreadsheet, which was originally created in Excel 97,
when opened in Excel 2000 exhibits a problem during
calculation. The spreadsheet contains no VB code and no
circular references, but does contain large VLOOKup
ranges, which in total exceed the limits mentioned on the
www.decisionmodels.com web site (i.e. more than 65536
dependencies).

In manual calculation mode, pressing F9 causes the
calculation to begin. The status bar shows the calculation
% climbing to 100%, but then the status bar message
displays ‘TABLE: 1’. Once this status message is
displayed, Excel seems to hang up whilst consuming all
processor resource. Clicking anywhere on the spreadsheet
(or pressing any key) causes status bar table number to
increment e.g. ‘TABLE: 3’ then ‘TABLE: 5’. Following the
final mouse click the status bar displays READY CALCULATE.

In automatic calculation mode, it behaves much the same as
above, except that once READY CALCULATE is displayed, the
calculation starts once again after a short delay and the
whole process repeats.

If the spreadsheet is saved in Excel 2000 then re-opened
in Excel 97. Excel 97 then exhibits the same problem.

Does the collective have any idea how I could solve this
problem.

Thanks in advance
Podger
 
I have solved the problem. Basically when TABlE: n is
displayed on the task bar, the spreadsheet is calculating
data tables. I didn't appreciate that when opening a
spreadsheet for the first time in Excell 2000 it causes
the whole spread sheet to be recalculated. I estimate that
the total runtime for this activity will be about 10
hours. I'll just have to patient and wait for it to
complete.

Podger
 
Have you tried the calculation option 'automatic except tables' ?


Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

I have solved the problem. Basically when TABlE: n is
displayed on the task bar, the spreadsheet is calculating
data tables. I didn't appreciate that when opening a
spreadsheet for the first time in Excell 2000 it causes
the whole spread sheet to be recalculated. I estimate that
the total runtime for this activity will be about 10
hours. I'll just have to patient and wait for it to
complete.

Podger
 
Back
Top