Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
I was looking to get assistance with a formula in Excel 2002 | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
formula required for excel 2002 | Excel Discussion (Misc queries) |