+ Reply to Thread
Results 1 to 4 of 4

Reach cells detected as containing inconsistent formula ?

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    Toulouse, France
    MS-Off Ver
    Excel 2003
    Posts
    3

    Reach cells detected as containing inconsistent formula ?

    Hello,
    I know that Excel (at least Excel 2003) shows a small green triangle in the upper left corner of a cell when it detects an inconsistent formula in it.
    My problem: I have a huge data table, and I would avoid the tedious process to go through "visually" all cells one by one to see if Excel detects cells contain formulas that seem inconsistent.
    So my question: [B] Is there a way to achieve (automatically), cell by cell (in the manner of "Search"), every cell contains a formula detected as inconsistent with Excel? [/ B]

    Thank you for your help.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Reach cells detected as containing inconsistent formula ?

    interesting question. Why would your formulae be inconsistent? do you change your sheet often? how about a macro that recopies the formula across all cells rather than trying to check if they are correct?

  3. #3
    Registered User
    Join Date
    04-18-2012
    Location
    Toulouse, France
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Reach cells detected as containing inconsistent formula ?

    There are plenty of reasons leading to possibly have inconsistent formulas.
    (For instance, when copying a full row (containing formulas) and inserting it elsewhere, according the way the formulas are built (or according other formulas in the rest of the spreadsheet) it can result that some formulas become inconsistent (It is the responsibility of the user to be aware and to know how all formulas are connected each other and to know the possible impacts of doing operation such as insert, delete or move cells).
    Sometimes, you just work on an Excel file initially created by someone else, you simply note that there are some cells with inconsistent formulas (and you do not know why)
    Anyway the topic of my post is to find a way to reach easily cells detected by Excel as containing inconsistent formulas (and correct then formulas if needed).
    Ideally, I hope a solution exists and that it can be done using only Excel abilities but if someone has an idea on how to make a macro in VBA that could make the job I am listening to your advice.

  4. #4
    Registered User
    Join Date
    04-18-2012
    Location
    Toulouse, France
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Reach cells detected as containing inconsistent formula ?

    The solution:
    On Excel 2003, menu "Tools" ---> then (in french menu) "Vérifications des erreurs..." (the third choice in the menu "Tools")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1