SOLVED

circular reference warning stops me opening the file in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-177833%22%20slang%3D%22en-US%22%3Ecircular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177833%22%20slang%3D%22en-US%22%3EI%20am%20using%20Office%202013%20also%20Office%20365%20on%20other%20laptop.%20I%20have%20a%20worksheet%20I%20have%20been%20using%20for%20almost%202%20years%20without%20a%20problem%20and%20have%20been%20updating%20every%20single%20day%2C%20However%20I%20can%20no%20longer%20access%20the%20file%20because%20it%20comes%20up%20with%20a%20'circular%20reference'%20warning%20and%20won't%20let%20me%20get%20any%20further%20the%20excel%20wont%20open%20its%20just%20blank.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-177833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20laptop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178042%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178042%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20time%20and%20support%20brother%20..%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178041%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178041%22%20slang%3D%22en-US%22%3Ethat%20is%20nice%20of%20you%20that%20you%20wrote%20on%20how%20you%20found%20the%20solution%20to%20the%20issue%2C%20that%20is%20why%20I%20marked%20your%20answer%20as%20%22best%20response%20and%20answer%22%20to%20the%20issue.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178040%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178040%22%20slang%3D%22en-US%22%3EI%20know%20how%20much%20i%20have%20struggled%20till%20now%20and%20how%20important%20the%20data%20is%20for%20me%20..%20one%20person%20had%20same%20problem%20and%20he%20posted%20in%20this%20same%20forum%20bt%20then%20he%20commented%20then%20that%20he%20found%20a%20way%20to%20fix%20his%20file%20so%20just%20ignore%20his%20post...%20bt%20he%20never%20mentioned%20how%20he%20did%20it..%20so%20i%20hope%20whoever%20will%20have%20this%20type%20of%20problem%20then%20these%20steps%20might%20help%20him%2Fher..%20happy%20to%20recover%20all%20my%20data%20..%20thanks%20again%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178039%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178039%22%20slang%3D%22en-US%22%3EYou%20are%20welcome.%20Thanks%20for%20the%20feedback.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178038%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178038%22%20slang%3D%22en-US%22%3ELastly%20i%20could%20open%20it%20...%20i%20opened%20a%20new%20excel%20file..%20go%20to%20file%2Foptions%2Fformulas%2Fcirculation%20options%2F%20select%20to%20manual%2C%20then%20press%20ok%2C%20then%20go%20to%20file%20again%20select%20open%20select%20the%20target%20file%20then%20at%20the%20option%20of%20(open)%20near%20the%20file%20name%20select%20open%20and%20repair%2C%20should%20bring%20up%20repair%20and%20extract%20data%20option%20select%20extract%20data%20then%20select%20recover%20formulas%20select%20ok%20again%20and%20it%20openes%20perfectly%20...%20thank%20you%20for%20all%20the%20help%20and%20your%20time%20everyone%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178033%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178033%22%20slang%3D%22en-US%22%3E%3CP%3Esome%20follow%20up%20questions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewhat%20happens%20if%20you%20open%20another%20file%3F%20will%20it%20open%20correctly%3F%20is%20it%20just%20this%20file%20that%20causing%20the%20issue%3F%3C%2FP%3E%0A%3CP%3EDo%20you%20have%20any%20workbook%20in%20your%20Excel%20start%20up%20folder%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ecould%20you%20post%20a%20screenshot%20of%20the%20grayed%20out%20excel%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178032%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178032%22%20slang%3D%22en-US%22%3EAppreciate%20your%20reply%20..%20True%2C%20but%20it%20does%20not%20open%2C%20after%20the%20error%3CBR%20%2F%3E%20*A%20circular%20reference%20can%20be%20a%20formula%20that%20refers%20to%20its%20own%20cell%20value%2C%20or%20refers%20to%20a%20cell%20dependent%20on%20its%20own%20cell%20value%20*%20i%20select%20ok%2C%20then%20it%20says%20*you%20can%20continue%20without%20updating%20their%20values%2C%20or%20edit%20the%20links%20you%20think%20are%20wrong*%20i%20select%20continue%20(both%20options%20tried)%20then%20its%20blank%20and%20all%20option%20are%20greyed%20out%20cant%20do%20any%20changes%20to%20formula%20options%20or%20anything%20else%20..%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178005%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178005%22%20slang%3D%22en-US%22%3EYou%20can%20temporarily%20disable%20that%20warning%20by%20File%20%26gt%3B%20Options%20then%20Formulas%20Enable%20iterative%20calculation%20and%20see%20if%20you%20can%20open%20the%20file%20and%20if%20it%20has%20data.%20%3CBR%20%2F%3EIf%20you%20do%20not%20see%20any%20data%2C%20then%20probably%20your%20excel%20file%20is%20corrupted.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071070%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%20warning%20stops%20me%20opening%20the%20file%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F133381%22%20target%3D%22_blank%22%3E%40Zainool%20Budha%3C%2FA%3E%26nbsp%3BHi%2C%20I%20have%20read%20the%20response%20which%20was%20given%20to%20open%20the%20circular%20reference%20but%20i%20am%20unable%20to%20follow%20the%20step%20to%20open%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERequest%20if%20you%20can%20guide%2C%20as%20even%20I%20have%20one%20file%20which%20I%20was%20using%20for%20some%20years%20now%20and%20suddenly%20i%20have%20started%20getting%20this%20warning%20message%20and%20file%20is%20not%20opening%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20the%20data%20in%20that%20is%20very%20critical.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
I am using Office 2013 also Office 365 on other laptop. I have a worksheet I have been using for almost 2 years without a problem and have been updating every single day, However I can no longer access the file because it comes up with a 'circular reference' warning and won't let me get any further the excel wont open its just blank.

Thanks
10 Replies
You can temporarily disable that warning by File > Options then Formulas Enable iterative calculation and see if you can open the file and if it has data.
If you do not see any data, then probably your excel file is corrupted.
Appreciate your reply .. True, but it does not open, after the error
*A circular reference can be a formula that refers to its own cell value, or refers to a cell dependent on its own cell value * i select ok, then it says *you can continue without updating their values, or edit the links you think are wrong* i select continue (both options tried) then its blank and all option are greyed out cant do any changes to formula options or anything else ..

some follow up questions.

 

what happens if you open another file? will it open correctly? is it just this file that causing the issue?

Do you have any workbook in your Excel start up folder?

 

could you post a screenshot of the grayed out excel? 

best response confirmed by Jamil Mohammad (Super Contributor)
Solution
Lastly i could open it ... i opened a new excel file.. go to file/options/formulas/circulation options/ select to manual, then press ok, then go to file again select open select the target file then at the option of (open) near the file name select open and repair, should bring up repair and extract data option select extract data then select recover formulas select ok again and it openes perfectly ... thank you for all the help and your time everyone
You are welcome. Thanks for the feedback.

I know how much i have struggled till now and how important the data is for me .. one person had same problem and he posted in this same forum bt then he commented then that he found a way to fix his file so just ignore his post... bt he never mentioned how he did it.. so i hope whoever will have this type of problem then these steps might help him/her.. happy to recover all my data .. thanks again
that is nice of you that you wrote on how you found the solution to the issue, that is why I marked your answer as "best response and answer" to the issue.
Thanks for your time and support brother ..

@Zainool Budha Hi, I have read the response which was given to open the circular reference but i am unable to follow the step to open the same.

 

Request if you can guide, as even I have one file which I was using for some years now and suddenly i have started getting this warning message and file is not opening at all.

 

Please help the data in that is very critical.

 

 

I followed your steps and tried opening the file through open but it still doesn't open. I don't see open &repair options either. Any suggestions ?

@Zainool Budha