| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate appears in status bar
Hi,
I have a rather large spreadsheet (apx 30MB) and all of a sudden the calculate message kept reapearing in the status bar at the bottom. I am in manual mode so I hit F9 and it calculates to a certain level and then goes back to show calculate. I don't show having a circular and my itirations is off and I don't show any links to other documents. Since the file is rather large and I have a bunch of formulas linking all over the place I tried to erase my most formula heavy sheets and see what happens, but Calculate remains. I have read all the posts on the issue and nothing seems to help me. Any ideas???? Thanks a bunch. Neda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate appears in status bar
You will get this if there are more than 64K cell dependencies.
The workbook does calculate properly, but the message appears in the status bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "neda5" wrote in message ... Hi, I have a rather large spreadsheet (apx 30MB) and all of a sudden the calculate message kept reapearing in the status bar at the bottom. I am in manual mode so I hit F9 and it calculates to a certain level and then goes back to show calculate. I don't show having a circular and my itirations is off and I don't show any links to other documents. Since the file is rather large and I have a bunch of formulas linking all over the place I tried to erase my most formula heavy sheets and see what happens, but Calculate remains. I have read all the posts on the issue and nothing seems to help me. Any ideas???? Thanks a bunch. Neda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate appears in status bar
Thanks.
However, I deleted most of the formulas to make sure that I don't have more than the limit of cell dependencies and it still gives me that message. Any other ideas? Thanks "Chip Pearson" wrote: You will get this if there are more than 64K cell dependencies. The workbook does calculate properly, but the message appears in the status bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "neda5" wrote in message ... Hi, I have a rather large spreadsheet (apx 30MB) and all of a sudden the calculate message kept reapearing in the status bar at the bottom. I am in manual mode so I hit F9 and it calculates to a certain level and then goes back to show calculate. I don't show having a circular and my itirations is off and I don't show any links to other documents. Since the file is rather large and I have a bunch of formulas linking all over the place I tried to erase my most formula heavy sheets and see what happens, but Calculate remains. I have read all the posts on the issue and nothing seems to help me. Any ideas???? Thanks a bunch. Neda |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate appears in status bar
The message does not go away until you close and reopen Excel.
see http://www.decisionmodels.com/calcsecretsf.htm Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "neda5" wrote in message ... Thanks. However, I deleted most of the formulas to make sure that I don't have more than the limit of cell dependencies and it still gives me that message. Any other ideas? Thanks "Chip Pearson" wrote: You will get this if there are more than 64K cell dependencies. The workbook does calculate properly, but the message appears in the status bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "neda5" wrote in message ... Hi, I have a rather large spreadsheet (apx 30MB) and all of a sudden the calculate message kept reapearing in the status bar at the bottom. I am in manual mode so I hit F9 and it calculates to a certain level and then goes back to show calculate. I don't show having a circular and my itirations is off and I don't show any links to other documents. Since the file is rather large and I have a bunch of formulas linking all over the place I tried to erase my most formula heavy sheets and see what happens, but Calculate remains. I have read all the posts on the issue and nothing seems to help me. Any ideas???? Thanks a bunch. Neda |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate appears in status bar
Thanks. That worked.
"Charles Williams" wrote: The message does not go away until you close and reopen Excel. see http://www.decisionmodels.com/calcsecretsf.htm Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "neda5" wrote in message ... Thanks. However, I deleted most of the formulas to make sure that I don't have more than the limit of cell dependencies and it still gives me that message. Any other ideas? Thanks "Chip Pearson" wrote: You will get this if there are more than 64K cell dependencies. The workbook does calculate properly, but the message appears in the status bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "neda5" wrote in message ... Hi, I have a rather large spreadsheet (apx 30MB) and all of a sudden the calculate message kept reapearing in the status bar at the bottom. I am in manual mode so I hit F9 and it calculates to a certain level and then goes back to show calculate. I don't show having a circular and my itirations is off and I don't show any links to other documents. Since the file is rather large and I have a bunch of formulas linking all over the place I tried to erase my most formula heavy sheets and see what happens, but Calculate remains. I have read all the posts on the issue and nothing seems to help me. Any ideas???? Thanks a bunch. Neda |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate appears in status bar
Do you know if that limit is per sheet or for the entire workbook?
If I were to split my biger sheets in a few worksheets, should that solve the problem? Thanks. Neda "Charles Williams" wrote: The message does not go away until you close and reopen Excel. see http://www.decisionmodels.com/calcsecretsf.htm Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "neda5" wrote in message ... Thanks. However, I deleted most of the formulas to make sure that I don't have more than the limit of cell dependencies and it still gives me that message. Any other ideas? Thanks "Chip Pearson" wrote: You will get this if there are more than 64K cell dependencies. The workbook does calculate properly, but the message appears in the status bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "neda5" wrote in message ... Hi, I have a rather large spreadsheet (apx 30MB) and all of a sudden the calculate message kept reapearing in the status bar at the bottom. I am in manual mode so I hit F9 and it calculates to a certain level and then goes back to show calculate. I don't show having a circular and my itirations is off and I don't show any links to other documents. Since the file is rather large and I have a bunch of formulas linking all over the place I tried to erase my most formula heavy sheets and see what happens, but Calculate remains. I have read all the posts on the issue and nothing seems to help me. Any ideas???? Thanks a bunch. Neda |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate appears in status bar
These are the latest Microsoft words describing how these limits are changed
in Excel 12 (from David Gainer's Excel12 Blog). It is possible that you can avoid one or more of these limits by splitting large worksheets into multiple smaller worksheets. I have not tried it so I dont know. The number of cells that may depend on a single area before Excel must do full calculations instead of partial calculations (because it can no longer track the dependencies required to do partial calculations) Old Limit: 8k New Limit: Limited by available memory The number of different areas in a sheet that may have dependencies before Excel must do full calculations instead of partial calculations (because it can no longer track the dependencies required to do partial calculations) Old Limit: 64k New Limit: Limited by available memory "neda5" wrote in message ... Do you know if that limit is per sheet or for the entire workbook? If I were to split my biger sheets in a few worksheets, should that solve the problem? Thanks. Neda "Charles Williams" wrote: The message does not go away until you close and reopen Excel. see http://www.decisionmodels.com/calcsecretsf.htm Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "neda5" wrote in message ... Thanks. However, I deleted most of the formulas to make sure that I don't have more than the limit of cell dependencies and it still gives me that message. Any other ideas? Thanks "Chip Pearson" wrote: You will get this if there are more than 64K cell dependencies. The workbook does calculate properly, but the message appears in the status bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "neda5" wrote in message ... Hi, I have a rather large spreadsheet (apx 30MB) and all of a sudden the calculate message kept reapearing in the status bar at the bottom. I am in manual mode so I hit F9 and it calculates to a certain level and then goes back to show calculate. I don't show having a circular and my itirations is off and I don't show any links to other documents. Since the file is rather large and I have a bunch of formulas linking all over the place I tried to erase my most formula heavy sheets and see what happens, but Calculate remains. I have read all the posts on the issue and nothing seems to help me. Any ideas???? Thanks a bunch. Neda |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate appears in status bar
Thanks. I am still struggling to solve that issue in Excel 2003. What really
puzzled me is that I have much larger files with tons of formulas and I never hit this issue before. I split the most formula heavy sheets, but it didn't seem to help. I am really at a loss. Excel 2007 seems to deal with that problem but until then... "Charles Williams" wrote: These are the latest Microsoft words describing how these limits are changed in Excel 12 (from David Gainer's Excel12 Blog). It is possible that you can avoid one or more of these limits by splitting large worksheets into multiple smaller worksheets. I have not tried it so I dont know. The number of cells that may depend on a single area before Excel must do full calculations instead of partial calculations (because it can no longer track the dependencies required to do partial calculations) Old Limit: 8k New Limit: Limited by available memory The number of different areas in a sheet that may have dependencies before Excel must do full calculations instead of partial calculations (because it can no longer track the dependencies required to do partial calculations) Old Limit: 64k New Limit: Limited by available memory |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create list of text matching criteria | Excel Worksheet Functions | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
| Urgent- Help ! (Message 'Calculate' Appears) | Excel Discussion (Misc queries) | |||
| Why does # of filtered rows appear in status bar only sometimes? | Excel Discussion (Misc queries) | |||
| Why is calculate showing in status bar at bottom of spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
