I'm having a problem with Excel hanging. The file size is about 5.6Mb. It also has about 50 tabs (worksheets). I've tried it in safe mode and it still hangs. I've deactivated the COM add ins. I fear the cause of this is the use of named ranges. I create tabs (worksheets) by copying an existing worksheet. When I look at the named ranges (Formulas > Name Manager), there are several instances of the variables, because they are copied from one worksheet to another. Most of the time, the scope is local, in that it refers to the worksheet. However, some are global and refer to the workbook. This concerns me because I'm not sure what variable Excel is using in the calculation, but also, with the number of instances, Excel is getting confused. It's going to take me quite a bit of work replacing the named ranges with absolute references, but, if this is the solution, I guess that is what I will do.

Am I missing something?

Is there something else I should look at?

TIA