XL98: Formulas Not Recalculated with Data Table in Workbook
ID: Q186461
|
The information in this article applies to:
-
Microsoft Excel Macintosh Edition
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.
- On the Data menu, click Table. Type $A$1 in the Column Input Cell box. Click OK.
- Activate Sheet2.
- Type the following on Sheet2:
A1: =RAND()
- Switch to Sheet1.
- Press SHIFT+F9. The data table is calculated.
- Switch to Sheet2.
- 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.
Additional query words:
XL98
Keywords : kbdta xlformula
Version : MACINTOSH:
Platform : MACINTOSH
Issue type : kbbug