The Not Responding condition is probably caused by the workbook being too busy at something to let the operating system know what is going on. For instance, if you have any VBA code running, and you have a tight loop that is being repeatedly processed, the workbook will hog the resources. In loops, I usually put the Doevents function - this forces Excel to speak to the OS and let something else have a turn.
Also, if you are doing thousands of recalculations on the sheet - that may cause a temporary freeze.
Although I use the 2007 version, I do not have a dual processor. Have you googled foe Excel dual processor problems? It seems like a recipe for disaster if you have 2 processors trying to share the otherwise monolithic code. It SHOULD work fine, but hey, we are talking Microsoft here.
That's all I can think of for now. |