Forum home » Delegate support and help forum » Microsoft Excel Training and help » Circular references

Circular references

ResolvedVersion 2007

Wed 10 Feb 2010, 16:10 Delegate VICTORIA said...

VICTORIA has attended:
Excel Intermediate course

Circular references

How can I get rid of the circular reference warning without turning off all error alerts?

Wed 10 Feb 2010, 16:46 Trainer Anthony said...

RE: Circular references

Hi Victoria, thanks for your query. Go to the Office Button, Excel Options and the formulas category. At the top right, make sure "Enable Iterative Calculation" is checked. This should permit the circular reference.

Hope this helps,

Anthony

Training courses

98.7 % 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Circular references

Circular references

RE: Circular references

Excel articles

Excel tip:

Using Alt in Save Dialog Box