This is a follow-up to a previous thread on a similar topic located here:
Which factors result in the most "sluggishness" in Excel?
1) After selecting Manual under Calculation Options in the Formulas tab (in Excel), why would any
type of delay* still remain? Aside from calculations, what other processes exist that could slow things down?
*Delay refers to a delay relative to a "control" spreadsheet which contains the same data placed there by Copy/PasteValue.
2) Something I have looked at in the past and never understood is the amount of the CPU capacity being devoted to a process occurring in Excel or some other application. In the task manager, under the Performance tab is a chart depicting CPU Usage (and another chart showing Physical Memory Usage). The CPU usage is given as a percentage and even during periods when a spreadsheet is completely unavailable due to some type of calculation process, etc., the CPU usage percent seems to always be <20%. Why doesn't it devote everything it's got to the task at hand -- knowing of course that it can always be diverted elsewhere if needed -- rather than holding >80% back? What is that >80% doing?
3) Does the number and size of other tabs in the same workbook have any effect on the time it takes to complete various processes in a spreadsheet?