Circular references in Excel: What they are and how to fix them




About this tutorial:

Video duration: 00:00:52
You’ve entered a formula in Excel, but it’s not working. Instead, you’ve got this message about a “circular reference.” Millions of people have the same problem, and it happens because your formula is trying to calculate itself, and you have a feature called iterative calculation turned off. Learn more at the Excel Help Center:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

7 thoughts on “Circular references in Excel: What they are and how to fix them

    karthik R

    (September 10, 2020 - 9:43 am)

    The biggest headache is that we have to include the current cell also and still get an answer.Why would you suggest to not include the current cell??
    Defeats the whole purpose of video.

    χρηστος Μπακολουκας

    (September 10, 2020 - 9:43 am)

    !!!!!!!!!

    B Grahm

    (September 10, 2020 - 9:43 am)

    You are absolutely best!!! Got it the first time. Thanks

    wroot

    (September 10, 2020 - 9:43 am)

    I thought there will be some intricate way to fix complex circular references. But this one is so simple, but true 😀

    andrewz61

    (September 10, 2020 - 9:43 am)

    Microsoft's code and bug testing has been going down hill for years. This common issue should have a "Did you mean this" pop up not an error. Maybe Microsoft should have some real world testing done and not drop some BS like "like we can't test for everything" as an excuse for shit logic!

    Paulo Souza

    (September 10, 2020 - 9:43 am)

    lol

    Josh eashappie

    (September 10, 2020 - 9:43 am)

    Should post more videos like this!

Leave a Reply

Your email address will not be published. Required fields are marked *