Excel 2016-Errors

BJS | 11:35 Sat 16th Jul 2016 | Computers

2 Answers

Can anyone tell me how to locate formula errors. I am sure in previos versions you could find a error check on one of the toolbars but cannot seem to locate it on the 2016 version. It would also locate the cell containing the error. Thanks for any help.

Microsoft Word On Windows Xp

Safely Remove Hardware Icon

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by BJS. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Buenchico

See 'Turn error checking rules on or off' here:
https://support.office.com/en-us/article/Detect-errors-in-formulas-3A8ACCA5-1D61-4702-80E0-99A36A2822C1?ui=en-US&rs=en-US&ad=US

BJS

Question Author

Hi Buenchico. Still getting nowhere. Ther is supposed to be a Error checking option on the Formula toolbar but cannot get it any at alll. The problem is when entering a particular Workbook the error message comes up

1 to 2 of 2

Do you know the answer?