How can I change a Name scope from local to Global in Excel 2007?
Question: I created a worksheet and duplicated it, along with the Names. I have edited the names but now those are scoped for that sheet only. The Name Manager won’t allow me to change the scope.
Answer: This is so easy that it’s not so obvious:
- Select the Named range on your worksheet whose scope you want to change;
- Open the Name Manager (Formulas tab) and select the name;
- Click Delete and OK;
- Click New… and type in the original name back in the Name field;
- Make sure Scope is set to Workbook and click Close.
See? That was way too easy!
Francis Hayes (The Excel Addict)