Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please!!!!!!!!
hi,
I have a worksheet with ten worksheets and in some of the worksheets there are simple formulas and two worksheets with array formula.from a couple of days age something is wrong with the file, whenever I put any data in any cell after clicking ENTER , the "calculating cell ..." comes at the bottom of the sheets and it's driving me crazy!.plz let me know how I can get rid of the calculating cell... .I had some macro that was written by me but I removed all of them. thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please!!!!!!!!
Check out this link
http://www.decisionmodels.com/calcsecretsf.htm -- HTH... Jim Thomlinson "peyman" wrote: hi, I have a worksheet with ten worksheets and in some of the worksheets there are simple formulas and two worksheets with array formula.from a couple of days age something is wrong with the file, whenever I put any data in any cell after clicking ENTER , the "calculating cell ..." comes at the bottom of the sheets and it's driving me crazy!.plz let me know how I can get rid of the calculating cell... .I had some macro that was written by me but I removed all of them. thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please!!!!!!!!
hi Jim,
I've gone thru the website but I don't have any problem regarding the circular reference or something like that.How come I didn't have such problem before?!!eventhough I had many macros and visual basic codes!! "Jim Thomlinson" wrote: Check out this link http://www.decisionmodels.com/calcsecretsf.htm -- HTH... Jim Thomlinson "peyman" wrote: hi, I have a worksheet with ten worksheets and in some of the worksheets there are simple formulas and two worksheets with array formula.from a couple of days age something is wrong with the file, whenever I put any data in any cell after clicking ENTER , the "calculating cell ..." comes at the bottom of the sheets and it's driving me crazy!.plz let me know how I can get rid of the calculating cell... .I had some macro that was written by me but I removed all of them. thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please!!!!!!!!
Since you said you have array formulas is it possible that you have blow
through the dependency limit. It is easier to do than you think... -- HTH... Jim Thomlinson "peyman" wrote: hi Jim, I've gone thru the website but I don't have any problem regarding the circular reference or something like that.How come I didn't have such problem before?!!eventhough I had many macros and visual basic codes!! "Jim Thomlinson" wrote: Check out this link http://www.decisionmodels.com/calcsecretsf.htm -- HTH... Jim Thomlinson "peyman" wrote: hi, I have a worksheet with ten worksheets and in some of the worksheets there are simple formulas and two worksheets with array formula.from a couple of days age something is wrong with the file, whenever I put any data in any cell after clicking ENTER , the "calculating cell ..." comes at the bottom of the sheets and it's driving me crazy!.plz let me know how I can get rid of the calculating cell... .I had some macro that was written by me but I removed all of them. thanks, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please!!!!!!!!
So what should I do now?but I had the same formula before but the
"calculating cell..." speed to reach 100% was extremely higher than now!! "Jim Thomlinson" wrote: Since you said you have array formulas is it possible that you have blow through the dependency limit. It is easier to do than you think... -- HTH... Jim Thomlinson "peyman" wrote: hi Jim, I've gone thru the website but I don't have any problem regarding the circular reference or something like that.How come I didn't have such problem before?!!eventhough I had many macros and visual basic codes!! "Jim Thomlinson" wrote: Check out this link http://www.decisionmodels.com/calcsecretsf.htm -- HTH... Jim Thomlinson "peyman" wrote: hi, I have a worksheet with ten worksheets and in some of the worksheets there are simple formulas and two worksheets with array formula.from a couple of days age something is wrong with the file, whenever I put any data in any cell after clicking ENTER , the "calculating cell ..." comes at the bottom of the sheets and it's driving me crazy!.plz let me know how I can get rid of the calculating cell... .I had some macro that was written by me but I removed all of them. thanks, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please!!!!!!!!
Assuming you have reached the limit then there is not too much you can do.
Usually this happens when you use XL more like a database than a spreadsheet. My guess is that your sheets have very large data sets on them? The only things you can do is to try to minimixe the number of dependencies. 1. Do not open other workbooks along with this one. The dependency limit is at the application level and not the workbook level. 2. Remove as many calculations as possible. Perhaps have macros perform some of the calculations and hard code the results into the cells. -- HTH... Jim Thomlinson "peyman" wrote: So what should I do now?but I had the same formula before but the "calculating cell..." speed to reach 100% was extremely higher than now!! "Jim Thomlinson" wrote: Since you said you have array formulas is it possible that you have blow through the dependency limit. It is easier to do than you think... -- HTH... Jim Thomlinson "peyman" wrote: hi Jim, I've gone thru the website but I don't have any problem regarding the circular reference or something like that.How come I didn't have such problem before?!!eventhough I had many macros and visual basic codes!! "Jim Thomlinson" wrote: Check out this link http://www.decisionmodels.com/calcsecretsf.htm -- HTH... Jim Thomlinson "peyman" wrote: hi, I have a worksheet with ten worksheets and in some of the worksheets there are simple formulas and two worksheets with array formula.from a couple of days age something is wrong with the file, whenever I put any data in any cell after clicking ENTER , the "calculating cell ..." comes at the bottom of the sheets and it's driving me crazy!.plz let me know how I can get rid of the calculating cell... .I had some macro that was written by me but I removed all of them. thanks, |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please!!!!!!!!
thanx Jim.
"Jim Thomlinson" wrote: Assuming you have reached the limit then there is not too much you can do. Usually this happens when you use XL more like a database than a spreadsheet. My guess is that your sheets have very large data sets on them? The only things you can do is to try to minimixe the number of dependencies. 1. Do not open other workbooks along with this one. The dependency limit is at the application level and not the workbook level. 2. Remove as many calculations as possible. Perhaps have macros perform some of the calculations and hard code the results into the cells. -- HTH... Jim Thomlinson "peyman" wrote: So what should I do now?but I had the same formula before but the "calculating cell..." speed to reach 100% was extremely higher than now!! "Jim Thomlinson" wrote: Since you said you have array formulas is it possible that you have blow through the dependency limit. It is easier to do than you think... -- HTH... Jim Thomlinson "peyman" wrote: hi Jim, I've gone thru the website but I don't have any problem regarding the circular reference or something like that.How come I didn't have such problem before?!!eventhough I had many macros and visual basic codes!! "Jim Thomlinson" wrote: Check out this link http://www.decisionmodels.com/calcsecretsf.htm -- HTH... Jim Thomlinson "peyman" wrote: hi, I have a worksheet with ten worksheets and in some of the worksheets there are simple formulas and two worksheets with array formula.from a couple of days age something is wrong with the file, whenever I put any data in any cell after clicking ENTER , the "calculating cell ..." comes at the bottom of the sheets and it's driving me crazy!.plz let me know how I can get rid of the calculating cell... .I had some macro that was written by me but I removed all of them. thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|