Circular References

Resolved · Low Priority · Version 2003

Wed 14 May 2008, 16:30 Delegate Bayly said...

Bayly has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course

Circular References

How to you create a circular reference

Thu 15 May 2008, 13:15 Trainer Katie said...

RE: Circular References

Hi Bayly,

In Excel, circular reference usually happens if you write a formula/function (e.g. Sum, Average, if statement...etc) on the source number cell.

Usually, formula/function should be placed on a blank cell.

If you get a circular reference warning, press Esc to cancel & press Esc again to abort the formula. Put in the formula again but in a blank cell.

Hope that clears it up.

Kind regards,

Katie Woo
Microsoft Certified Trainer

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips