XL98: Formulas Not Recalculated with Data Table in Workbook (186461)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
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:
  1. Start Microsoft Excel 98 and create a new workbook.
  2. On the Tool menu, click Preferences, click the Calculation tab, and then select Manual. Click OK.
  3. Type the following on Sheet1: 
           A1:     B1: =A1+1
       A2: 1   B2:
  4. Select A1:B2.
  5. On the Data menu, click Table. Type $A$1 in the Column Input Cell box. Click OK.
  6. Activate Sheet2.
  7. Type the following on Sheet2:

    A1: =RAND()

  8. Switch to Sheet1.
  9. Press SHIFT+F9. The data table is calculated.
  10. Switch to Sheet2.
  11. Press SHIFT+F9.
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.

REFERENCES

For more information about data tables, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

data tables, overview

and then click Show Topics. Select the "Ways to forecast values with what- if analysis" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB186461
©2002 Microsoft Corporation. All rights reserved.