Circular Reference - Fixing Circular Reference in Excel 2013

When a cell use its own reference in formula, then it is called circular reference.We can fix circular reference by selecting File then Options then in Formula, checking the Enable Iterative Calculation option.

[@fortuneins3504]

Troubled for hours until this video helps solving the problem instantly. THANKS!

[@carolinesogomo2479]

You explained so well. Keep making more videos.

[@karthik007]

Finally problem solved and I feel like I am in heaven now.

[@karthikeyan-wd7zi]

Same bro

[@knockuptrader55]

Fantastic!.. it's really working. Thanks a lot

[@akshaymanchekar3628]

this video solved my problem …Thank you

[@ExcelDestination]

thanks

[@jeffshaw9472]

Thank you, Options > Formula was the fix! :-)

[@alexanderschmidt75]

He actually used the circular reference options. I have used to solve partial differential equations, it's a great tool.

[@MdSamim-zw6hz]

Finally Problem solved. Thank U Very Much.

[@ExcelDestination]

welcome

[@sidkhan9871]

Very Good Bro 👍👍👍

[@danielenoh8046]

thank you. This saved me

[@fakih9349]

The best .. very very very beesstt thanks

[@ExcelDestination]

Most welcome

[@solomonshewa9245]

tnx bro u solve my bigest problem.

[@bhanuprakashyerramsetty7379]

Very informative. Thanks dear

[@AKVlogs804]

Thanks man problem solved 💯

[@akashsinghrajput2126]

You are god like that for me...i love you..❤️❤️❤️❤️❤️ my problem has been slove

[@ExcelDestination]

Glad to hear that

[@naveenchkaravarthi7869]

Thank u so much, i had cleared my error abd going to subscribe your channel.

[@ExcelDestination]

Welcome 👍

[@vishaljaronde2490]

Thankss Boss....

[@ExcelDestination]

Welcome

[@1000frolly]

THANK YOU!

[@prajwalwaikar6772]

Thanks for the help !!!!

[@ExcelDestination]

welcome

[@issacselvin]

Thanks you ☺️

[@ExcelDestination]

welcome

[@Rajforu21]

Thanks buddy . It helped a lot . 👍👍

[@ExcelDestination]

welcome

[@user-xq6vj1uv2e]

Thanks, Mister.

[@ExcelDestination]

Very welcome

[@Dexteenie_Onos]

This just made my day thank u so much

[@EJBuzzella]

Thank you for this! Circular reference error finally fixed after error checking didnt work.

[@adhamsakran3297]

Thank u

[@Keepingupwithpiku]

Its helpful thanks

[@ExcelDestination]

Welcome

[@pritikiduniya7703]

Thank you so much

[@shriramparmar8059]

Good video

[@hamedahmadi2722]

Very useful 👍👍

[@ExcelDestination]

thanks

[@ashwinigudekar5709]

Thanks a ton!!!!!!!

[@ExcelDestination]

You're welcome!

[@manishsharma8497]

Thank you👍

[@manojmanyar9337]

Thank u so much😍🤟🤟

[@ExcelDestination]

Welcome 😊

[@tharuwish299]

This saved me, Thank you

[@ExcelDestination]

Glad to hear it!

[@AnonymousHippo5]

Why does excel does not remember/save the fact that you enable iterative calculations? The error pops up at random times when you open this saved file and you have to go check the enable box again. The file is being opened up by the same user and on the same PC every time it is being used. How would this issue be fixed? Thanks

[@AmitKumar-jb9gy]

Thank you Sir

[@ExcelDestination]

Welcome!

[@danixyaal]

❤️❤️

[@ExcelDestination]

Thanks

[@Anandblackbird]

Thanks for that 😊

[@ExcelDestination]

Welcome 😊

[@anantharaj2807]

Too Good, thanks a lot

[@ExcelDestination]

Thank you!

[@pastorbernardtudzi3436]

Great. Thanks a lot

[@ExcelDestination]

Thanks for your comment!

[@bikramchoudhury9199]

Thanks a lot

[@batistasimons3121]

when I input a number in a particular cell, I want that number to change in that same cell, based on a formula I'm using. for instance, when I'm in cell A1; when I input 30, I want the 30 to change to 0.9( 30% of 30) automatically... how am I gonna do it.?

[@morainhoms7098]

that is too good, thank

[@ExcelDestination]

Thanks for watching!

[@rocketbunny0989]

it's been 6 years and how many soul have u saved?

[@shiprasati2042]

When we save the file, still the addition takes place

[@pallabibanerjee452]

Wow

[@breaktime7060]

Ok..But if is enter value in any cell and press ente then cell A4 value also changed..How to stop that

[@ExcelDestination]

this error occurs only, if we use same cell in formula while calculation.

[@tutorialyoutube2024_KangUji]

love you stomach ❤️

[@bounyithofficial7197]

Hi

[@ExcelDestination]

hello

[@aksharvala8801]

THODA JOR SE BOL BHAI

[@geetaparveen1474]

Speak louder🔊

[@AbdihakimHAress]

Thank you

[@ExcelDestination]

Welcome

[@pavantidke8582]

Thank you so much..

[@ExcelDestination]

Welcome

[@kirtikarol7718]

thanks you

[@ExcelDestination]

Welcome

[@MKS-hn6eb]

thankyou so much

[@yemiogundipe6200]

Thank you

[@user-lf6bz7ob8u]

thank you

[@ExcelDestination]

Welcome!