Forum Discussion
Name Manager How to change the scope?
Excel for Mac Name manager has finally been added (many core features are still MIA though). Edit a name. Scope is disabled as something that cannot be altered! Not sure why that should be ...
PrivateUser1066 If you already have named a range they seem to default to "Workbook" on a Mac. But when you create one from within the name Manager, you can choose Workbook or the relevant sheet name.
hi.
thanks for this.
For me, the scope field is disabled (grey) rather than a list. This is true of all of the names that I have tried (I stopped after the first 25+ !).
I have the latest version of Excel 365 for mac (as of yesterday).
When I get a chance, I have just thought to try it with a new workbook (Sometimes I amaze myself with my dimness!). On more than one occasion, inconsistencies seem to follow a particular workbook.