Link to home
Start Free TrialLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Excel Name Manager Clean Up

I have a WB that I have had for some time now and it has evolved quite nicely.   However, in all of the adds (WSs and code) and deletes, when I go to "Name Manager" I realize that I have many names now that are no longer valid or have #REF next to them.  What assumption may I use in deleting or cleaning up the long list of what I believe to be invalid Names that now reside in my Name Manager?  All of my macros, WSs and calculations seem to work..... is there a way to make sure I don't screw up by deleting something important?

Thank you,

B.
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bright01

ASKER

I'll try your approach.

Thank you!

b.