Correct a #REF! error

Microsoft Office Excel 2003

previous page next page
  • Click the cell that displays the error, click the button that appears Button image, and then click Trace Error if it appears.
  • Review the possible causes and solutions.

    • Possible causes and solutions

    ShowDeleting 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 Button image immediately after you delete or paste the cells.

    ShowUsing a link to a program that is not running

    Start the program.

    ShowLinking to a Dynamic Data Exchange (DDE) topic such as "system" that is not available

    Make sure that you're using the correct DDE topic.

    ShowRunning a macro that enters a function that returns #REF!

    Check the function to see if an argument refers to a cell or range of cells that is not valid. For example, if the macro enters a function that refers to a cell above the function, and the cell that contains the function is in row 1, the function will return #REF! because there are no cells above row 1.

    previous page start next page