SITEMAP ABOUT
MiC Quality

FREE COURSE Excel Primer

  PROCESS IMPROVEMENT AND SIX SIGMA
ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
FREE TRIAL
:: Online Courses
:: Free Trial
>> Statistics Module
>> Excel Primer
:: Six Sigma
:: FAQ
:: Brochures
:: Licenses
:: Discounts
 
Welcome to MiC Quality
Online Course Instructor
Glen Netherwood
MiC Quality
Online Learning
:: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: Circular References Syllabus    PreviousNext


Sooner or later you will find Excel complaining about ‘Circular References’. This is often caused by a typing error (I do it all the time!) so I'll take a moment to tell you what it means and how to fix it.

The example below shows the problem in its simplest form. I’ve put the formula ‘=C3’ in ‘D3’ and ‘=D3’ in 'C3'.

The value in ‘C3’ depends on the value in ‘D3’ and the value in ‘D3’ depends on the value in ‘C3’, there is no solution (in this case any value would satisfy the conditions).

Circular references can be easy to spot, or it can take hours to puzzle out the problem. You might have to trace back through several links in the chain until you find the loop. It may be an obvious mistake, or it may be quite a subtle problem with your logic.

This example shows the chain of links that involves four cells. D7=D3; D3=C3, C3=C7; C7=D7:

You can follow the blue 'precedence' or 'dependence' arrows to help figure out the problem. Otherwise check out the Help system to find more powerful diagnostic tools.


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy