Microsoft KB Archive/186461

= XL98: Formulas Not Recalculated with Data Table in Workbook =

Article ID: 186461

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q186461





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



CAUSE
This problem may occur when the following conditions are true:
 * You click Preferences on the Tools menu and select Manual on the Calculation tab to enable 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 containing the data table is active to recalculate only the active worksheet. -and-


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



WORKAROUND
To work around this problem, press COMMAND+SHIFT+F9 to completely recalculate all open workbooks in Microsoft Excel.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.



MORE INFORMATION
To see an example of the problem that is described in this article, follow these steps:  Start Microsoft Excel 98 and create a new workbook. On the Tool menu, click Preferences, click the Calculation tab, and then select 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> Activate 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">