XL98: Hard Disk Name Appears in Formula or Defined Name

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, if you copy a worksheet, the following problems may occur.

Case 1

A linking formula may be changed so that the name of the hard disk appears in the formula.

For example, if a formula should appear as follows

   =[Workbook1]Sheet1!A1

   ='Freds DiskDes:ktop Folder:[Workbook1]Sheet1'!A1

Case 2

Defined names may be changed so that the name of the hard disk appears in the formula.

For example, if a defined name should refer to the following

   =[Workbook1]Sheet1!A1

   ='Freds DiskDes:ktop Folder:[Workbook1]Sheet1'!A1

CAUSE

Case 1

The first problem (in which a formula is changed) may occur when the following conditions are true:

• The workbook to which the formulas are linked (for example, Workbook1) is stored on a floppy disk drive, hard disk drive, network drive (shared disk), or random access memory (RAM) disk, and the disk name is exactly ten characters in length, including spaces. For example, the disk is named either of the following:

        Freds Disk
        MyPowerMac
  

      -and-
  

• You copy a worksheet that contains links to the workbook, either by clicking Move Or Copy Sheet on the Edit menu or by pressing CONTROL and clicking the worksheet tab, and then clicking Move Or Copy on the shortcut menu.

  It does not matter which workbook contains the worksheet you are copying. What matters is that the formulas are linked to the specific workbook (Workbook1, in this example).

Case 2

The second problem, (in which a defined name is changed) may occur when the following conditions are true:

• The workbook to which the formulas are linked (for example, Workbook1) is stored on a floppy disk drive, hard disk drive, network drive, or RAM disk, and the disk name is exactly ten characters in length, including spaces. For example, the disk is named either of the following:

        Freds Disk
        MyPowerMac
  

      -and-
  

• You copy a different worksheet in the same workbook that contains the defined name.

  For example, if the defined name refers to a cell in Sheet1, you copy Sheet2 or Sheet3, and then copy the worksheet into another workbook.

RESOLUTION

To prevent these problems from occurring, make sure that the names of your hard disk drive, floppy drive, or RAM disk are not exactly ten characters in length.

If any of your network drives have names that are exactly ten characters in length, contact your network administrator to see if it is possible to rename the network drive. Otherwise, store your workbooks on a different network drive, or on a local hard disk with a name that is not ten characters in length.

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.

MORE INFORMATION

Examples

Case 1: Linking Formulas Are Changed

To see an example of this behavior, follow these steps:

1. Quit all running programs.

2. In the Finder, select the icon for your hard disk. Click the title once. Type "Freds Disk" (without the quotation marks) and press RETURN.

3. Start Microsoft Excel. Note that the program may take longer than usual to start; this is because Microsoft Excel must re-register itself after you rename the hard disk.

4. In Sheet1, enter the value 100 in cell A1.

5. In Sheet2, enter the following formula in cell A1:

         =Sheet1!A1
   

6. On the File menu, click Save. Click the Desktop button. Change the file name to "Workbook1" (without the quotation marks) and click Save.

7. Do either of the following:

       a. With Sheet2 still active, click Move Or Copy Sheet on the Edit
          menu. Select the Create A Copy checkbox and click OK.
   

       -or-
   

       a. Create a new workbook. In Sheet1 of the new workbook, enter the
          following formula in cell A1:
   

             =[Workbook1]Sheet1!A1
   
       b. On the Edit menu, click Move Or Copy Sheet. Select the Create A
          Copy checkbox and click OK.
   
   

   ='Freds DiskDes:ktop Folder:[Workbook1]Sheet1'!A1

Case 2: Defined Names Are Changed

To see an example of this behavior, follow these steps:

1. Quit all running programs.

2. In the Finder, select the icon for your hard disk. Click the title once. Type "Freds Disk" (without the quotation marks) and press RETURN.

3. Start Microsoft Excel. Note that the program may take longer than usual to start; this is because Microsoft Excel must re-register itself after you rename the hard disk.

4. In the new workbook, select cell A1 in Sheet1. In the Name box (to the left of the formula bar), type "test" (without the quotation marks) and press RETURN.

5. On the File menu, click Save. Click the Desktop button. Change the file name to "Workbook1" (without the quotation marks) and click Save.

6. Select Sheet2. On the Edit menu, click Move Or Copy Sheet. In the list box, click "(new book)." Select the Create A Copy check box, and click OK.

   A new workbook is created and activated.

7. On the Insert menu, point to Name, and then click Define. Click "test" in the Names In Workbook list.

   ='Freds DiskDes:ktop Folder:[Workbook1]Sheet1'!$A$1