Excel 2007 Named Ranges - can i edit the Scope of a named range?

Posted by rachel PM | on Tue, 25/08/2009 - 15:16 7127 3 comments | report

I've copied some sheets that had named ranges in them and this has copied the named ranges across too. Excel allows duplicate named ranges but then makes the Scope of that named range specific to the sheet it occurs in. I have renamed the ranges to make them unique but the Scope still shows as the actual sheet rather than the whole workbook. Does anyone know how i can chnage the Scope back to workbook without having to delete and recreate all of the named ranges?

Comments

You need to change it from Local to Global

ACDWebb | Tue, 25/08/2009 - 15:43 | Permalink

I find the Excel Name Manager addin found here - http://www.jkp-ads.com/officemarketplacenm-en.asp - very useful and it will handle the Local/Global change for you

accountingweb already has the answer!

gsgordon | Wed, 26/08/2009 - 10:34 | Permalink

See the reference to the Scope drop-down in http://www.accountingweb.co.uk/item/175623 . This would appear to allow you to change the scope of any Name to Global and solve your problem - I hope it does.

Excel 2007 Named Ranges - can i edit the Scope of a named range?

fsardmore | Fri, 05/03/2010 - 23:53 | Permalink

Rachael,

I am sure you have solved your problem a long time ago. I did not want to download 3rd party software on my work computer. The workaround I used was to copy the source worksheet with names to a new workbook. I renamed all of the names in the new workbook and copied the worksheet back into the original workbook.