XL98: Clicking Row or Column Divider Causes Recalculation

ID: Q184441

The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you click a row or column divider, formulas in all open workbooks are recalculated.


CAUSE

This problem occurs if both of the following conditions are true:

  • The calculation mode for the active workbook is set to Automatic.


    • -and-

  • You click the row or column divider but do not resize the column or row.



WORKAROUND

To work around this problem, set the calculation mode to Manual. To do this, follow these steps:

  1. On the Tools menu, click Preferences.


  2. In the Preferences dialog box, click the Calculation tab. Click Manual to select the manual calculation mode.


NOTE: when you use the manual calculation mode, formulas are not automatically recalculated. This may cause formulas to appear to be incorrect. To recalculate the values on the sheet at any time, press F9.


STATUS

Microsoft has confirmed this to be a problem with the Microsoft products listed at the beginning of this article.


REFERENCES

For more information about calculation in workbooks, 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

calculating formulas, overview
and then click Show Topics. Select the "About calculation in workbooks" 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:98
Platform : MACINTOSH
Issue type : kbbug


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.