Microsoft KB Archive/94635

= Microsoft Knowledge Base =

Excel: Incorrect Values in Data Fill Range with ATP Regression
Last reviewed: September 12, 1996

Article ID: Q94635

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS
In version 4.0 of Microsoft Excel, if you use one of the Fill commands immediately after you use the Regression analysis tool (available in the Analysis ToolPak add-in macro), the data in the fill range will temporarily display incorrect results.

WORKAROUND
To display the correct values in the fill range, you must repaginate the worksheet. To repaginate the worksheet, do one of the following:

 Print the document. -or- View the document in print preview. -or- Use your scroll bars to scroll the screen. -or- Select the affected cells and press the F2 key and then press the ENTER key (if you are using Windows) or press F2 and the RETURN key (if you are using a Macintosh computer).

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem was corrected in version 5.0 of Microsoft Excel for Windows.

MORE INFORMATION
When you perform a data fill on a cell that contains a formula, that formula is copied to the fill range. If you perform a data fill immediately after you use the Regression analysis tool, the cells in that range may display incorrect values even though they contain the correct formulas. This problem occurs because the document has not been repaginated. The document must be repaginated in order for the correct values to be displayed.

You will receive similar results if you use the mouse to drag the fill handle.

Note: Your data fill may work correctly if you scroll the screen when you copy the information to the new cells. Scrolling will cause the screen to repaginate, and the problem may not occur.

Recalculating the document will not correct this problem.