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

[@danielenoh8046]

thank you. This saved me

[@MdSamim-zw6hz]

Finally Problem solved. Thank U Very Much.

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

[@AKVlogs804]

Thanks man problem solved 💯

[@sidkhan9871]

Very Good Bro 👍👍👍

[@solomonshewa9245]

tnx bro u solve my bigest problem.

[@akashsinghrajput2126]

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

[@ExcelDestination]

Glad to hear that

[@1000frolly]

THANK YOU!

[@naveenchkaravarthi7869]

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

[@ExcelDestination]

Welcome 👍

[@fakih9349]

The best .. very very very beesstt thanks

[@ExcelDestination]

Most welcome

[@EJBuzzella]

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

[@Dexteenie_Onos]

This just made my day thank u so much

[@bhanuprakashyerramsetty7379]

Very informative. Thanks dear

[@yemiogundipe6200]

Thank you

[@issacselvin]

Thanks you ☺️

[@ExcelDestination]

welcome

[@prajwalwaikar6772]

Thanks for the help !!!!

[@ExcelDestination]

welcome

[@user-xq6vj1uv2e]

Thanks, Mister.

[@ExcelDestination]

Very welcome

[@Rajforu21]

Thanks buddy . It helped a lot . 👍👍

[@ExcelDestination]

welcome

[@adhamsakran3297]

Thank u

[@tharuwish299]

This saved me, Thank you

[@ExcelDestination]

Glad to hear it!

[@pritikiduniya7703]

Thank you so much

[@manishsharma8497]

Thank you👍

[@Keepingupwithpiku]

Its helpful thanks

[@ExcelDestination]

Welcome

[@pavantidke8582]

Thank you so much..

[@ExcelDestination]

Welcome

[@vishaljaronde2490]

Thankss Boss....

[@ExcelDestination]

Welcome

[@MKS-hn6eb]

thankyou so much

[@ashwinigudekar5709]

Thanks a ton!!!!!!!

[@ExcelDestination]

You're welcome!

[@shriramparmar8059]

Good video

[@manojmanyar9337]

Thank u so much😍🤟🤟

[@ExcelDestination]

Welcome 😊

[@kirtikarol7718]

thanks you

[@ExcelDestination]

Welcome

[@hamedahmadi2722]

Very useful 👍👍

[@ExcelDestination]

thanks

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

[@rocketbunny0989]

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

[@Anandblackbird]

Thanks for that 😊

[@ExcelDestination]

Welcome 😊

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

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

[@danixyaal]

❤️❤️

[@ExcelDestination]

Thanks

[@pallabibanerjee452]

Wow

[@user-lf6bz7ob8u]

thank you

[@ExcelDestination]

Welcome!

[@shiprasati2042]

When we save the file, still the addition takes place

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