What does OLE stands for?

Object Linking and Embedding

The correct answer is option 2- Object Linking and Embedding.

Correct a #REF! Error-  This error occurs when a cell reference (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.) is not valid.

1. Optionally, click the cell that displays the error, click the button that appears, and then click Show Calculation Steps if it appears.

2. Review the following possible causes and solutions:

• Deleting cells referred to by other formulas, or pasting moved cells over cells referred to by other formulas.
• Change the formulas, or restore the cells on the worksheet by clicking Undo immediately after we delete or paste the cells.
• Using an Object Linking and Embedding (OLE) link to a program that is not running.
• Start the program.