XL97: Error Saving or Closing Files with Defined Names (172709)

CAUSE

This problem may occur when all of the following conditions are true:

• You create two workbooks in Microsoft Excel 97, and the workbooks are open.
  
  For example, you create workbooks Book1 and Book2. -and-
  
  
• In one workbook (Book1), you create a defined name (for example, Name1) that references a relative cell address in the other workbook (Book2). -and-
  
  
• In the workbook (Book1) that contains the defined name (Name1), you create another defined name (for example, Name2) that uses the first defined name (Name 1) in a function.
  
  For example, you create the following names in Book1.

       Defined name   Refers to                      Examples
    
  
        Name1          A relative or a mixed            =[Book2]Sheet1!A1:B5
                         relative cell range                     =[Book2]Sheet1!$A1:$B5
                         in another open                       =[Book2]Sheet1!A$1:B$5
                         workbook (Book2)
  
        Name2          Name1 in a function            =AVERAGE(Name1)
                                                                         =SUM(Name1)
  						

  -and-
  
  
• In the workbook (Book1) that contains the defined names, you enter a formula that refers to the defined name that uses the first defined name in a function (Name2).
  
  For example, you enter the following function:

        =Name2

  -and-
  
  
• You attempt to save Book1, or you close Book2.

NOTE: The problem does not occur in earlier versions of Microsoft Excel. Also, the problem does not occur if the range referenced by Name1 uses absolute cell referencing (for example, =[Book2]Sheet1!$A$1:$B$5) or if Name2 does not use Name1 in a function (for example, =Name1, for example).