| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Formulas stop calculate correctly after 13.4MB
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 formulas stop to calculate correctly. May I know under Excel 2002, if there is a limit for the formulas to wrrk correctly ? What about Excel 2007, does it has a higher limit for this ? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Formulas stop calculate correctly after 13.4MB
What does "stop to calculate correctly" mean exactly? What formulas?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Mr. Low" wrote in message ... | 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 formulas stop to calculate | correctly. | | May I know under Excel 2002, if there is a limit for the formulas to wrrk | correctly ? | | What about Excel 2007, does it has a higher limit for this ? | | Thanks | | Low | -- | A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Formulas stop calculate correctly after 13.4MB
Hello Niek,
What I mean is the formulas give the incorrect answer. Eg. B1 = 58,000.00 B2 = 58,000.00 B3 = B2-B1=5200 By right at B3 the answer should be 0.00. My speadsheets have a lot of SUMIF( ) formulas that search for answers in other pages. The results are then link to many pages. I find that the recaulcution speed is very slow when I save the file. Thanks Low -- A36B58K641 "Niek Otten" wrote: What does "stop to calculate correctly" mean exactly? What formulas? -- Kind regards, Niek Otten Microsoft MVP - Excel "Mr. Low" wrote in message ... | 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 formulas stop to calculate | correctly. | | May I know under Excel 2002, if there is a limit for the formulas to wrrk | correctly ? | | What about Excel 2007, does it has a higher limit for this ? | | Thanks | | Low | -- | A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Formulas stop calculate correctly after 13.4MB
Try rebuilding the dependency tree.
Two methods: - CTRL+ALT+SHIFT+F9, I don't know in which version this was introduced, maybe after 2002. - Find and replace (CHTL+H) all equal signs with equal signs. Has to be done per sheet, but maybe only necessary for the sheet with the formulas. Save your work first before trying! -- Kind regards, Niek Otten Microsoft MVP - Excel "Mr. Low" wrote in message ... | Hello Niek, | | What I mean is the formulas give the incorrect answer. | | Eg. B1 = 58,000.00 | B2 = 58,000.00 | B3 = B2-B1=5200 | | By right at B3 the answer should be 0.00. | | My speadsheets have a lot of SUMIF( ) formulas that search for answers in | other pages. The results are then link to many pages. I find that the | recaulcution speed is very slow when I save the file. | | | Thanks | | Low | | | | -- | A36B58K641 | | | "Niek Otten" wrote: | | What does "stop to calculate correctly" mean exactly? What formulas? | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Mr. Low" wrote in message ... | | 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 formulas stop to calculate | | correctly. | | | | May I know under Excel 2002, if there is a limit for the formulas to wrrk | | correctly ? | | | | What about Excel 2007, does it has a higher limit for this ? | | | | Thanks | | | | Low | | -- | | A36B58K641 | | | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Formulas stop calculate correctly after 13.4MB
(CHTL+H) should of course ne (CTRL+H)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | Try rebuilding the dependency tree. | Two methods: | - CTRL+ALT+SHIFT+F9, I don't know in which version this was introduced, maybe after 2002. | - Find and replace (CHTL+H) all equal signs with equal signs. Has to be done per sheet, but maybe only necessary for the sheet | with the formulas. | | Save your work first before trying! | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Mr. Low" wrote in message ... || Hello Niek, || || What I mean is the formulas give the incorrect answer. || || Eg. B1 = 58,000.00 || B2 = 58,000.00 || B3 = B2-B1=5200 || || By right at B3 the answer should be 0.00. || || My speadsheets have a lot of SUMIF( ) formulas that search for answers in || other pages. The results are then link to many pages. I find that the || recaulcution speed is very slow when I save the file. || || || Thanks || || Low || || || || -- || A36B58K641 || || || "Niek Otten" wrote: || || What does "stop to calculate correctly" mean exactly? What formulas? || || -- || Kind regards, || || Niek Otten || Microsoft MVP - Excel || || "Mr. Low" wrote in message ... || | 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 formulas stop to calculate || | correctly. || | || | May I know under Excel 2002, if there is a limit for the formulas to wrrk || | correctly ? || | || | What about Excel 2007, does it has a higher limit for this ? || | || | Thanks || | || | Low || | -- || | A36B58K641 || || || | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data don't enter correctly in Excel 2002 running under Vista | Excel Discussion (Misc queries) | |||
| excel 2002 gridelines not printing correctly | Excel Discussion (Misc queries) | |||
| How come Excel can't calculate any =SIN(x) or =COS(y) correctly? | Excel Discussion (Misc queries) | |||
| excel does not calculate sums correctly | Excel Discussion (Misc queries) | |||
| Excel won't calculate my formulas correctly. | Excel Worksheet Functions | |||
Hybrid Mode
