Die deutsche Fassung finden Sie hier.
Scenario: You want to enter a formula into a cell where normally only certain values are allowed, e.g. cells like "Stock Availability:
When you enter a formula in this kind of cell you get this message:
Solution: Disable Data Validation for the cell (or all cells of this type)
- While the cell is still selected, Go to Data -> Data Validation -> Data Validation,
2. in Data Validation go to Error Alert and uncheck Show error alert after invalid data is entered,
optionally turn of validation for all cells of this type: still in Data Validation go to Settings and check Apply these changes to all other... ,
3. then click OK and re-enter the formula in the cell.
Further help on Data Validation is provided by Microsoft:
Enter and format data
Apply data validation to cells - enabling, formating and FAQs
More on data validation - disabling, errors and troubleshooting