• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 935
  • Last Modified:

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,

1 Solution
There is no easy way to tell if something has a dependent which will impact down stream.
When I see many unrully names in the list I tend to go by the rule that if it has #REF then it wouldn't work anyway, so delete it.

Other than that there is little else other than saving the file before changing it and taking the plunge to see what deleting others do.
Bright01Author Commented:
I'll try your approach.

Thank you!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now