Reference

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-training · Excel-courses-london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Reference

Vicky has attended:
Excel Intermediate course

by - delegate Vicky [1 post] (2008 Mar 26 Wed, 16:32) Reply

How do I resolve a circular reference

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: reference

by - trainer Pete platinum contributer [799 posts] (2008 Mar 27 Thu, 10:06) Reply

Hi Vicky, Thank your for your post, Welcome to the forum, in answer to your question, first off a circular reference is where the cell which you wish to have your answer in is contained in the formula or function, to resolve the problem you will have to redo your formula or function so that the cell reference is not mentioned in it. You will get a whole heap of directions from Excel if you do create a circular reference, but to resolve the problem in the easiest and quickest way follow the steps above. best regards Pete

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Customized Financial Excel Courses in London
· Tips for Transitioning to Excel 2007
· What's Better Than the Help Function in Excel? Microsoft Training
· Excel Macros for the Non-Programmer

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips