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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Find & Replace The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below.DOWNLOAD WORKBO...
Split First & Last Name Using Text to Columns There are times when you receive a data set of employee full names in one column and you want to separate the full name into first name and surname in separate columns.One way is to use the Power Query method, which is great if you have lots of data that gets added each day, ...
Filter Unique Records The Advanced Filter allows you to filter unique records and copy them to another location outside the data set.  This is useful when you want to use a filtered list for further analysis.This can also be achieved by using a Pivot Table.  Placing a Field in the Row Labels will ...
Excel Paste Special: A Values Multiplier Paste Special has a few different Paste features and operations that many users do not know about.One of them is the Paste Special > Values > Multiply combination.What that does is multiply a range of selected cells by a value, called the multiplier.  So if you want...