View original (French)

Cell that disappears in Excel

Solved
Mag -  
 margotine6 -
Hello,

I have a little problem with Excel; when I write in a cell and hit enter, the cell clears by itself, even though everything was working fine yesterday. Does anyone have a remedy?
Thanks

11 answers

  1.
    Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     
    The cell seems empty; so be it!
    But what's in the formula bar?
    --
    Retirement is great! Especially in the Caribbean ... :-)
    ☻ Raymond ♂
    2
  2. Maflu
     
    Hello,

    I was looking at your post because I had the same issue. Not finding a solution, I went back to my Excel page and miracle, I solved the problem! Here’s what I did (sorry, my Excel 2010 is in English): select the problem cell(s), and click on the "Conditional Formatting" menu in the "Home" tab; then at the bottom choose "Clear Rules" and "From Selected Cells", or "From Entire Sheet" if the problem isn't locatable...
    That's it!
    1
  3. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    Wouldn't the ink be the same color as the paper?
    0
  4. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hi,

    There must be something like what Patrice or Raymond described to you, but given the urgency of the follow-up, it shouldn't be too much of a hassle.

    Highlight a range of cells that includes your cell, which should normally be filled in. For example, enter something in cell C3 and highlight the range A1 to D10.

    What do you see through the grayed-out selection?

    See you later
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    0
  6. Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     
    Did you do a virus search?
    --
    It's nice, retirement! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0
  7. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Re,

    Strange your story, can you make your file available to us if it doesn't contain any confidential notes
    click on one of these links/browse to select your file/create the link and paste the generated link in a next post

    https://www.cjoint.com/ or http://www.cijoint.fr/

    --
    Talk to you soon
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    0
    1. Mag
       
      Sorry, it's a document for a client study that I cannot share. Additionally, it is working properly now. If I ever encounter the same issue with another file, I won't hesitate to contact you again. Thank you.
      0
    2. Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
       
      We may then be less eager...
      0
  8. margotine6
     
    Hello,
    I am encountering the same problem; when I type in an Excel cell, it automatically clears if I use TAB or even if I use the mouse to switch cells.
    Thank you in advance for your feedback.
    0
  9. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    Each case is a particular case; we need to start by looking at the font color, then make sure that no conditional formatting is interfering, and maybe check if there is any VBA code that might be taking the input range into account.

    Can you tell me more about your problem?

    --
    A+
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    0
  10. margotine6
     
    Hello Mike,
    So I'm encountering this problem in all my Excel files; when I create a new sheet there’s no problem, until I save it, after that I can’t work on it anymore. (and it’s not opened in read-only).
    Font color checked.
    Thank you.
    0
  11. Mag
     
    Thank you for the advice, but the white screen issue is not it. It happens to me regularly, and I have to restart the computer, and then the Excel file works again. So on Friday, my problem was resolved by restarting, but it will happen again. I thought it was an Excel option issue, like sometimes when the automatic calculations of formulas switch to manual without us having touched anything.
    To be continued, if the problem recurs...
    -1
    1. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
       
      Could it be a macro that's causing the problem?
      0
    2. Mag
       
      No macros present in this workbook.
      0
  12. Mag
     
    It might be a virus, but McAfee doesn't find anything. The mystery remains. In any case, thank you for your suggestions.
    -1