The instruction under "Zoek en zoek de cel in Circular Reference" was very-very-very helpful !

MS-Help does not give this solution.

Locating the Cell In Circular Reference was nicely explained with steps........... I fixed the error..... thank you very much

Thank you! Simple and short explanation, without writing a ton of paragraphs of why finding circular references is important :)

thank you, I thought it would be even simpler by just clicking on the statement in the status bar. your explanation was spot on.

Thank you. I have been looking for the error for two hours and found it in 10 minutes with your help!

Thanks for help. This is an increase in my knowledge.

Hi, thanks for the instructions - but the lower entry (Circular references) of the error checking list is grayed out. No luck in making it selectable - ever.

Error checking is not a properly working feature of Excel generally. Had to switch off four of the selections under options, formular, error checking - otherwise these keept demanding changes to cells/formulars, which were fully correct.

A calculate command now takes 5 minutes - then the invisible checking for circular references begins - and takes another 2-3 minutes. Then you get one circular reference listed in the status line. Having studied that formular and tracked it, Excel says that the offset formular is a circular reference - but a direct reference to the resulting address is OK!

Have now spent a weeks time on trying to hunt down these spooks of circular references, which overload my PC entirely (20 minutes to do a save as command).

Trying to get help from Microsoft, I really like these helping words from Microsoft Support:

[i]While you're looking, check for indirect references. They happen when you put a formula in cell A1, and it uses another formula in B1 that in turn refers back to cell A1. [u]If this confuses you, imagine what it does to Excel.[/u][/i]

Poor Excel, bad user(s) ...

If it is only me being unsuccesfull in solving the circular references problems - then I'm happy for all of you ... Otherwise, a little bit of confort to you, keep fighting - there must be a way to manage this degrading of error management in Excel 2013. But using Microsoft Office has opened up another cost account for my job ...

awesome! Thank you!:-* :-* :-*

Short sweet answer. Popped up on Google right under MS support which I routinely skip past. Thanks!!!

Thank you for saving my entire life and removing that burden of looking for errors.

You eased my headache.
Thank you.

Thank you, hard to find the solution but easy to fix. Your guidance was right on.

Thank you so much!!!!

Thanks a million ;)very helpful & easy to follow instructions.

thanks a lot Admin i am happy with solution

You just saved me a ton of time. Thank-you so much.

So easy once you learn it. :roll: Thank you!!

Awesome! So clear it fixed up my problem and saved me tons of time browsing through sheets and sheets looking for it manually!

very nice and quick. thanks.

THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!! This was diving me crazy!!!!!!!!

I have this same warning popping up when I open a workbook.
However, I have checked each sheet within the workbook and no sheet reports a circular reference. I have even executed the Formula Auditing=>Error Checking individually on each sheet and no sheet reports a circular reference. It's only reported when I open the workbook. Any ideas on how to find out what excel is complaining about on open?

Thanks. Have been reading that stupid error for weeks and first solution I found was yours and the directions were super simple.

Thanks for the quick fix

Many Thanks, solved in two minutes!! :lol:

Thanks, clear and simple instruction for an irritating problem :-)

Thanks for the help. Saved me hours going through all the sheets

GREAT stuff, quick n easy, also easy the stress :lol:

You fixed my HEACACHE!! :-)

Awesome stuff :)
Saved me :)

Thank you so much. You saved my life.

Thank you, this was annoying me greatly

U saved me,Thank you

Excellent...easy peasy now. Thanks!

THANK YOU VERY MUCH !!!

Excellent advice, spreadsheet is a lot tidier now :)

thanks a lot mate for your advice

This is a lovely and useful tip. Thanks

thanks SO much. i was about to re-do the whole file when i stumbled upon this!

Awesome! You saved my day! :lol:

This was excatly what I needed and your tip was wonderful.
Thanks for making this so easy.

Perfectly explained and exactly what I needed! Thank you!

Brilliant save me so much time. Tried MS help rubbish unless you knew where it was. :-*

This was exactly the reply I was searching.... Thanks

This indeed solved my worries, also it saved me from probable and possible disasters that might happen due to circualar reference errors.
thanks a lot to all.

THNAK YOU VERY MUCH!!!!

Thanks much! VERY helpful!

THANKS....
SAVED ME FROM AN ERROR

:-x

:-) Big simile... quick and easy way.. thanks..

Just what I needed, and in such a clear, precise manner.
Thanks =)

Could not agree more with the comment of "inquirer" - you are my saviour indeed !

It is really stupid of Microsoft to only give the warning in the pop up message and not inform on how to find the circ. reference. I had a big excel file and it was taking several minutes to open each time because of this circ. reference problem.

Thanks a lot !!