Excel 2002 : Need patching for formula failures
 

Hi,

I was working on a formula intensive file of 13.4MB with many link pages.

I noticed that up to a certain limit, the calculation becomes very slow and
the formulas stop to give the correct answers. Eg: 25000-15000 should be 5000
but but the answer is now say 2300.

May I know if this is a program bug or that the limit for Excel 2002 formulas.

Appreciate very much if you could prepare a patching to enable me to use the
formulas correctly up to 25MB.

Thanks

Low



A36B58K641

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Excel 2002 : Need patching for formula failures
 

There is no patch to help you speed up and control large workbooks.

See Charles Williams' calculation secrets site.

http://www.decisionmodels.com/


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 07:40:02 -0700, Mr. Low
wrote:

Hi,

I was working on a formula intensive file of 13.4MB with many link pages.

I noticed that up to a certain limit, the calculation becomes very slow and
the formulas stop to give the correct answers. Eg: 25000-15000 should be 5000
but but the answer is now say 2300.

May I know if this is a program bug or that the limit for Excel 2002 formulas.

Appreciate very much if you could prepare a patching to enable me to use the
formulas correctly up to 25MB.

Thanks

Low



A36B58K641

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc