excel duplicate range name warning

K

Key_masteruk

When copying worksheets in excel it is possible to duplicate range name
causing local (worksheet specific) range names. Sometimes Excel warn
you when this is going to happen, sometimes the warning does no
appear. Could anyone tell me the rules as to wether the warning i
given or no
 
V

Vaughan

I think you get the warning when there are formulae on the sheet you are copying referring to range names that could refer to either the new or the old workbook.
 
B

BrianB

Range names are set at 2 levels, Workbook level and WorkSheet level.

Normally, using Insert/Name/Define, the names are recorded at WorkBoo
level by Excel. We can use just the name in a formula. If an existin
name is re-defined the old reference is overwritten. There is no shee
name shown in the Insert/Name dialog. Macros can be used to overrid
this to set a name at WorkBook or WorkSheet level, or both.

Importing a sheet from another workbook *containing the same name
makes that name available to other sheets - but is specific to tha
sheet, so the reference must include the sheet name eg
ImportedSheet!rangename. The sheet name appears in the Insert/Nam
dialog if that sheet is selected at the time.

Importing a sheet from another workbook *containing a reference to* th
same name makes an external reference (Link) to that workbook. The nam
becomes WorkSheet specific. The external workbook/sheet name appears i
the Insert/Name dialog if that sheet is selected at the time.

Attempting to copy a formula containing an external range name to
local sheet already containing that name (at workbook or workshee
level) results in the message to let Excel know which one it shoul
use. Likewise trying to copy a formula containing a local range name t
a sheet containing the same external range name.

I think (hope) that is correct. :
 
Top