Microsoft KB Archive/186452

= XL97: Some Formulas Are Not Refreshed with Data Table in Workbook =

Article ID: 186452

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q186452





SYMPTOMS
When you calculate values in your Microsoft Excel worksheet, values in some cells may not be recalculated.



CAUSE
This problem may occur when the following conditions are true:


 * You click Options on the Tools menu and click Manual on the Calculation tab to turn on manual calculation. -and-


 * You click Table on the Data menu to create a data table on a worksheet in a workbook. -and-


 * You type formulas on other worksheets in the same workbook. -and-


 * You press SHIFT+F9 while the worksheet that contains the data table is active to recalculate values in only the active worksheet. -and-


 * You press SHIFT+F9 while any other worksheet that contains formulas is the active worksheet.



RESOLUTION
To correct this problem, obtain and install Microsoft Office 97, Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

151261 OFF97: How to Obtain and Install MS Office 97 SR-2

To temporarily work around this problem, press CTRL+ALT+F9 to completely recalculate all open workbooks in Microsoft Excel.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).



MORE INFORMATION
To see an example of the problem that is described in this article, follow these steps:

 Start Microsoft Excel 97 and create a new workbook. On the Tool menu, click Options, click the Calculation tab, and then click Manual. Click OK.  Type the following on Sheet1:       A1:     B1: =A1+1 A2: 1  B2:  Select A1:B2.</li> On the Data menu, click Table. Type $A$1 in the Column Input Cell box. Click OK.</li> Switch to Sheet2.</li>  Type the following on Sheet2: A1: =RAND </li> Switch to Sheet1.</li> Press SHIFT+F9. The data table is calculated.</li> Switch to Sheet2.</li> Press SHIFT+F9.</li></ol>

The formula in A1 of Sheet2 is not recalculated. The value in A1 of Sheet2 should change any time you press SHIFT+F9, but it remains the same value. The formula in A1 of Sheet2 also is not recalculated if you press F9 or change the mode of calculation to Automatic.

<div class="references_section">