I'm developing a workbook that makes extensive use of names, both for ranges and formulas. These names are defined with scope local to each worksheet, and there are many worksheets. When I make a copy of a worksheet of course it copies the names from the source sheet, with the result that In total there are almost 9000 names defined. Now it takes forever to save the workbook, or to make a copy of a worksheet. Has anyone else run into this type of problem, and what did you do? Thanks.