Microsoft Knowledge Base

WINDOWS   | MACINTOSH

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

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.

REFERENCES

For an Overview Of Working With Names, choose the Search button in Help and type:

   names, overview