Paulked,

So I tried getting rid of all the formulas and set it to Manual and it was running for 2 hours and then Excel was "Not Responding". Any ideas what else I can do? It runs on the test workbook that I sent to you. But with the larger workbook it doesn't execute.

Thanks.
Steve