This one is weird, even for me.
When I open a certain file, and then click on Formulas-->Name Manager, I get an hourglass for about 10-15 seconds and then nothing happens. I'm clicking on Name Manager so I can see all of the named ranges in the workbook.
I know the workbook has named ranges, and even if I add another one (using "Define Name") it still will not display the name manager window.
Anyone had this problem before. The file is riddled with named ranges because whenever I try to make a copy of an existing worksheet I get the pop-up bos telling em the named range alreayd exists on the destination sheet. I'd like to be able to us e Name Manager to trim down the use of named ranges but I can't even get it to open.
Anyone had a similar problem?
When I open a certain file, and then click on Formulas-->Name Manager, I get an hourglass for about 10-15 seconds and then nothing happens. I'm clicking on Name Manager so I can see all of the named ranges in the workbook.
I know the workbook has named ranges, and even if I add another one (using "Define Name") it still will not display the name manager window.
Anyone had this problem before. The file is riddled with named ranges because whenever I try to make a copy of an existing worksheet I get the pop-up bos telling em the named range alreayd exists on the destination sheet. I'd like to be able to us e Name Manager to trim down the use of named ranges but I can't even get it to open.
Anyone had a similar problem?