View original (French)

Excel - formula calculation

Solved
generalbob -  
 generalbob -
Hello, I am working on Excel 2010. On one of my worksheets, it is impossible to make the formulas work. It displays the formula instead of the result.
Strangely, this problem only occurs on sheet 1 of this file, the formulas work perfectly on sheet 2.
I have looked for solutions in the Office help and online, but none work.

In my attempts, I discovered that it actually treats the formulas as constants. Indeed, when I use "evaluate formula", it responds "the cell being evaluated contains a constant".

Any ideas?

Configuration: Windows 7 / Firefox 11.0

1 answer

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    For Excel 2010

    File
    Options
    Advanced Options
    Display options for this worksheet
    uncheck the box Formulas in cells instead of their results
    Validate Ok
    0
    1. generalbob
       
      No! I've tried that already. The problem is upstream; it doesn't even perform the operation. It doesn't recognize the formulas as formulas but as constants.
      0
    2. axion
       
      Hello,

      a suggestion;
      Check that there are no "spaces" in each incriminated formula, either inside or
      at the end of the formula in particular.
      In this case, Excel may treat it as text and the function is inactive.

      Best regards
      axion
      0
    3. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello
      can you edit a copy of your formulas for us here?
      best regards
      0
    4. generalbob
       
      It's mainly sums like:

      "=SUM(C71:E71)"

      What bothers me the most is that sheet 2 is not affected. I typed a line of 4-5 digits in the middle of the sheet for testing, and the SUM function adds them up perfectly.
      0
    5. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      You should let us know whether or not you have the quotes that you included in your message. If you do, please remove them.
      0