What is the "automatic recalculation" "manual re-count?"
Users questions: What is the automatic re-count? What is the manual re-count? In excel's where you can make these settings? The key is ** not manually re-checking, can reduce the open wait time after the worksheet? Most important thing is * * If using Manual, and will not affect the calculation of the formula inside the document node Fruit? My work table and there are many formulas and internal links, **- I think if the passage of key settings, can reduce the waiting time after opening a document how to do thank you
Experts answer: upstairs to a very clear by saying, your first a "key" the answer is "yes", the second "key" the answer is "no Will be. "But I think the automatic re-calculation to manual re-count is not a good way, this is a fish and bear's paw. I work in practice also encountered similar problems, some cells we hope it simply asked for a cell connected with data updates, it should be updated in time, unless you are in this Question is not sensitive. I suggest you from the simplified formula, remove unwanted features, to change table structure, optimize operating system. . . Start, this is the fundamental problem ah!