Spread Designer
To allow user-entered formulas
In the Spread Designer,
- From the Book menu, choose Environment or press the Environment button ( ) on the Book toolbar.
- On the General tab in the Sheet Environment Settings dialog box under Settings, select the Custom Formulas check box.
- Choose the OK or Apply button.