When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error.

This means that the formula refers to a cell that isn’t valid.

To get rid of this error message we have to select the cell(s) with this error, press CTRL+H to bring up the Find & Replace dialogue box and enter the following:

Find What: #REF!

Replace With:   (Leave this blank)

Press OK and it will clear the #REF! within the formula.

DOWNLOAD WORKBOOK

Replace the REF

HELPFUL RESOURCE:

728x90

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Extract Numbers Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is extracting the numbers from your text au...
Excel Number Formats – Thousands & Mill... Large numbers in Excel can be formatted so they can be shown in "Thousands" or "Millions". By using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions. You can even add som...
Create a Named Range in Excel Whenever I work with spreadsheets, there's no escaping the fact that I have to work with a lot of ranges. Some of these ranges I have to reuse time and time again to create different calculations! Good thing there are Named Ranges in Excel! By using a Named Range, you ca...
Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...