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

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
There are 3 comments. Login or register to view them.

You need to change it from Local to Global

ACDWebb |
ACDWebb's picture

accountingweb already has the answer!

gsgordon |

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

fsardmore |