PSS ID Number: 139166
Article Last Modified on 1/20/2003
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q139166
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. 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.
Additional query words: crash lock up freeze
Keywords: KB139166
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch