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

Lock & Protect Formula Cells If you have a workbook with lots of formulas and you want to protect those formulas from being amended by other people who share your workbook, then you can! You need to follow these steps: 1. Press the Go To Special shortcut CTRL+G 2. Select the Constants box and press ...
Turn Text Dates To Excel Dates With Text To Column... Whenever you import data from your company's server, ERP system or any other source for that matter, the Dates usually come in a TEXT format. I will show you a cool trick where you can turn the TEXT Date to a values Date that Excel can read and work with. DOWNLOAD EXCEL WOR...
Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button. The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Highlight All Excel Formula Cells Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done: 1.Select all the cells in your Excel worksheet by clicking on the top left hand corn...