Microsoft KB Archive/114993

= Microsoft Knowledge Base =

XL: Copying Sheet Within Workbook Creates Local Copy of Name
Last reviewed: March 27, 1997

Article ID: Q114993

5.00 7.00 | 5.00

WINDOWS  | MACINTOSH kbusage

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0
 * Microsoft Excel for the Macintosh, version 5.0
 * Microsoft Excel for Windows 95, version 7.0

SYMPTOMS
In Microsoft Excel, if you create a global name that references a fixed array, such as ={"a","b","c"}, and you copy a sheet in the workbook to the same workbook, the copy of the worksheet contains a local name that references the array constant.

CAUSE
This behavior only occurs with names that reference a fixed array, such as {"a","b","c"}. For example, if you copy the sheet "Sheet1" in the workbook that contains the global name "Test" that refers to the fixed array {"a","b","c"}, to the same workbook, the local name that refers to the same fixed array is created with the following name on the copy of the sheet:

'Sheet1 (2)'!Test This does not occur with a name that references a constant value, such as 1.

WORKAROUND
When you copy a sheet within a book, to avoid having a duplicate local and global name that both refer to the same fixed array in your workbook, you can delete the local name from the copy of the sheet, and the global name remains in the workbook. The local name is essentially just a copy of the global name, and can be removed without losing the reference that you defined.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.