Forum Discussion
Name Manager question
Hi there, I am new to this Community and hope someone can help me with an excel issue. I am working in a workbook with several tabs where I have used Name Manager to reference different columns etc i...
It sounds as if you've inadvertently created names with local scope rather than workbook wide. Down toward the bottom of this linked page you'll see some suggestions for how to recognize that situation and correct it.
Hi Mathetes,
Thank you so much for responding and it seems you are right. I see that I have a mix of scope and the named ranges that are not appearing have a local scope opposed to those that appear and that I can use. Do I need to delete and recreate all the local named ranges?
Thank you so much for responding and it seems you are right. I see that I have a mix of scope and the named ranges that are not appearing have a local scope opposed to those that appear and that I can use. Do I need to delete and recreate all the local named ranges?
JKPieterse's excellent and free Name Manager add-in lets you change defined names from local to global (or vice versa).
- Thanks for this tip! I will certainly have a look at this solution.
Do I need to delete and recreate all the local named ranges?
That's certainly how I read the advice on that page (assuming you want them to be global in scope).
And then be careful going forward to make sure all named ranges are global in their scope.
- Yes, this seems as the only way to go about it. Thank you so much once again!
