• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

#REF! errors in Excel

by on
in Excel Training,Office Technology

Q. My formula suddenly started giving me #REF! errors. What went wrong?

A. Technically speaking, something in the formula refers to a value in a location it can’t find. If your formula refers to values in another workbook that have been moved to a different location or deleted, a #REF! error will result.

One way to start sleuthing the mystery is to use Trace Precedents. With your problem cell selected, on the Formulas tab, Formula Auditing group, click the Trace Precedents button. Double-click on the arrow head or line to start navigating to the various components in your formula.

If one of your components shows #REF! in the cell reference, it can no longer find the workbook or work sheet that this component referred to. If the problem is a different workbook, you can also refer to the Data tab, Connections group, Edit Links button. The button only appears if your workbook contains external links.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/34718/ref-errors-in-excel "

Leave a Comment