XL7: MS Excel Hangs When You Save a Pasted Transposed Function

ID: Q139166

7.00 WINDOWS kbusage

The information in this article applies to:

Microsoft Excel for Windows 95, versions 7.0

SYMPTOMS

When you save a worksheet in which you transpose a range of cells that contain one or more aggregate functions, Microsoft Excel for Windows 95 may hang (stop responding).

CAUSE

This problem occurs when all of the following conditions are true:

You transpose a range of cells that contains one or more aggregate functions
-and-
You use a range of cells as the argument in the function, for example:
```
      =SUM(A1:E1)
```
-and-
You use relative cell references when specifying the range of cells in the function.

WORKAROUND

To work around this problem, use absolute references when you specify the range of cells in the function, for example:

   =SUM($A$1:$E$1)

MORE INFORMATION

This problem may occur when you use the following functions:

   AVERAGE()          MEDIAN()
   AVEDEV()           MIN()
   COUNT()            PRODUCT()
   DEVSQ()            STDEV()
   GCD()              STDEVP()
   GEOMEAN()          SUM()
   HARMEAN()          SUMSQ()
   LCM()              VAR()
   MAX()              VARP()

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0a. A patch is also available that corrects this problem. For information about obtaining this patch, see following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q128650
   TITLE     : XL7 Patch Available: 15-Digit Number, Linking, and Transpose

NOTE: This problem does not occur in earlier versions of Microsoft Excel.

REFERENCES

For more information about using absolute cell reference, click the Index tab in Microsoft Excel Help, type the following text

   absolute cell

and then double-click the selected text to go to "The difference between relative and absolute references" topic.

KBCategory: kbusage kbfixlist KBSubcategory: xlwin

Additional reference words: 7.00 crash lock up freeze

Keywords          : xlwin kbfixlist
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: September 17, 1996