Microsoft KB Archive/180610

= XL98: Sheet Protection Does Not Disable Options Settings =

Article ID: 180610

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q180610



SYMPTOMS
When you protect a worksheet, Microsoft Excel 98 Macintosh Edition continues to allow calculation of formulas in the worksheet.



CAUSE
Microsoft Excel always updates the worksheet if you change any of the following in the Preferences dialog box:

Precision as displayed

Accept labels in formulas

1904 date system

NOTE: To view the Preferences dialog box, click Preferences on the Tools menu. Click the Calculation tab to view these options.



STATUS
This behavior is by design in Microsoft Excel 98 Macintosh Edition.

