I have about ten worksheets that I update every month. They are all the same but for different projects. They all have the same 7 macros in them. They have worked fine for about a year, but now when I run one of the macros, it freezes Excel for about 15-20 minutes. When I look at the task manager, it shows that Excel is running so I just wait and it always eventually unfreezes. Any ideas as to what is wrong? This happens when I run that macro on all of the worksheets.