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
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