Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: #NAME? Appears Copying Formulas to New Workbook

XL2000: #NAME? Appears Copying Formulas to New Workbook

View products that this article applies to.

This article was previously published under Q206358

↑ Back to the top

Symptoms

When you copy and paste cells containing formulas into another workbook, the #NAME? error may appear in the cells in the new workbook that contain formulas.

↑ Back to the top

Cause

This problem occurs when you copy cells containing formulas with row or column labels (also known as natural language formulas).

For example, this problem occurs when you copy cells A1:C4 in the following example into a new workbook. 
   A1: Sales   B1: North    C1: South
   A2: John    B2: 140      C2: 120  
   A3: Jane    B3: 130      C3: 110
   A4:         B4:          C4: =Jane South + Jane North

↑ Back to the top

Workaround

If you are copying cells that contain labels in formulas, select the Accept labels in formulas check box before you copy and paste your data. To do this, follow these steps:
  1. On the Tools menu, click Options.
  2. On the Calculation tab, click to select the Accept labels in formulas check box and click OK.

↑ Back to the top

More information

In Microsoft Excel 2000, the Accept labels in formulas option is off by default. This is different from Excel 97, in which this option is on by default.

If you open a workbook that uses labels in formulas, or natural language formulas, this option is enabled for that workbook.

↑ Back to the top

Keywords: KB206358, kbprb, kbnofix

↑ Back to the top

Article Info
Article ID : 206358
Revision : 3
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 190