LinkBack URL
About LinkBacks
Why it is that my excel work sheet always "Processor Calculating". It takes long time to process the calculation. What was wrong?
Always calculating
Why it is that my excel work sheet always "Processor Calculating". It takes long time to process the calculation. What was wrong?
without the file it's difficult to say.
maybe it is a huge file of calculations?
in that case you can put te calculations to manual.
excel 2007 => formula => countoptions.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Indeed this is a big file. I used to work with many big excel files but I don't encounter this problem. It makes me wonder what I did wrong to this file.. I tried the formula =>option => manual. I find this very time consuming as it does not calculate automatically when I modify or put formula.
Last edited by jeffreybrown; 12-30-2012 at 10:49 AM. Reason: As per Forum Rule #12, don't quote whole posts unless necessary-- it's just clutter.
Maybe you used a function to look up in the whole column (e.g. B:B) instead of a range (e.g. b1:b1500).
But without any file or formula, it's hard to tell.
Also beware of volatile functions and array formulas
Pepe, What do you mean by volatile function and array formulas.. Is there a way how to examine if the formula or array is volatile?
Originally Posted by Pepe Le Mokko
http://www.decisionmodels.com/calcsecretsi.htm
Hi
Check out the link for volitile functions
Chris
Click my star if I helped Thanks
http://www.xtremevbtalk.com/showthread.php?t=296012
An introduction to array formulas
Note that large workbooks containing many VLOOKUPS will also slow things down. According to various sources the INDEX/MATCH combination is faster and needs less resources
Guys, Thanks for the links... Yes I used Today() a lot..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks