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.

[@knockuptrader55]

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

[@karthik007]

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

[@karthikeyan-wd7zi]

Same bro

[@akshaymanchekar3628]

this video solved my problem …Thank you

[@ExcelDestination]

thanks

[@naveenchkaravarthi7869]

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

[@ExcelDestination]

Welcome 👍

[@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.

[@Dexteenie_Onos]

This just made my day thank u so much

[@fakih9349]

The best .. very very very beesstt thanks

[@ExcelDestination]

Most welcome

[@MdSamim-zw6hz]

Finally Problem solved. Thank U Very Much.

[@ExcelDestination]

welcome

[@akashsinghrajput2126]

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

[@ExcelDestination]

Glad to hear that

[@danielenoh8046]

thank you. This saved me

[@solomonshewa9245]

tnx bro u solve my bigest problem.

[@bhanuprakashyerramsetty7379]

Very informative. Thanks dear

[@1000frolly]

THANK YOU!

[@AKVlogs804]

Thanks man problem solved 💯

[@Rajforu21]

Thanks buddy . It helped a lot . 👍👍

[@ExcelDestination]

welcome

[@sidkhan9871]

Very Good Bro 👍👍👍

[@user-xq6vj1uv2e]

Thanks, Mister.

[@ExcelDestination]

Very welcome

[@EJBuzzella]

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

[@issacselvin]

Thanks you ☺️

[@ExcelDestination]

welcome

[@prajwalwaikar6772]

Thanks for the help !!!!

[@ExcelDestination]

welcome

[@AbdihakimHAress]

Thank you

[@ExcelDestination]

Welcome

[@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

[@Keepingupwithpiku]

Its helpful thanks

[@ExcelDestination]

Welcome

[@vishaljaronde2490]

Thankss Boss....

[@ExcelDestination]

Welcome

[@pritikiduniya7703]

Thank you so much

[@ashwinigudekar5709]

Thanks a ton!!!!!!!

[@ExcelDestination]

You're welcome!

[@manojmanyar9337]

Thank u so much😍🤟🤟

[@ExcelDestination]

Welcome 😊

[@manishsharma8497]

Thank you👍

[@shriramparmar8059]

Good video

[@tharuwish299]

This saved me, Thank you

[@ExcelDestination]

Glad to hear it!

[@hamedahmadi2722]

Very useful 👍👍

[@ExcelDestination]

thanks

[@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.?

[@AmitKumar-jb9gy]

Thank you Sir

[@ExcelDestination]

Welcome!

[@danixyaal]

❤️❤️

[@ExcelDestination]

Thanks

[@Anandblackbird]

Thanks for that 😊

[@ExcelDestination]

Welcome 😊

[@shiprasati2042]

When we save the file, still the addition takes place

[@anantharaj2807]

Too Good, thanks a lot

[@ExcelDestination]

Thank you!

[@bikramchoudhury9199]

Thanks a lot

[@pastorbernardtudzi3436]

Great. Thanks a lot

[@ExcelDestination]

Thanks for your comment!

[@morainhoms7098]

that is too good, thank

[@ExcelDestination]

Thanks for watching!

[@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.

[@rocketbunny0989]

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

[@pallabibanerjee452]

Wow

[@tutorialyoutube2024_KangUji]

love you stomach ❤️

[@bounyithofficial7197]

Hi

[@ExcelDestination]

hello

[@aksharvala8801]

THODA JOR SE BOL BHAI

[@geetaparveen1474]

Speak louder🔊

[@adhamsakran3297]

Thank u

[@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!