Computing Staff
  • 0

My Excel Spreadsheet Won’t Accept New Data

  • 0

I’m trying to enter data in a spreadsheet I use weekly. It will not enter anything (no numbers/no letters) in the highlighted space. My keyboard is working fine with Word and also with a new Excel spreadsheet.

Share

2 Answers

  1. When you enter a character in a cell
    and before you press enter
    can you see the character in the Formula Bar?
    I still think it could be your Font Color.

    Check to make sure there are no rogue Macros running
    and also check for any Conditional Formatting.

    Does it occur on all Sheets in the Workbook
    or just one specific sheet?

    What version of Excel are you using?
    If your on 2007 or newer, try saving the workbook in a different format like .xls
    and see if it continues to give the same problem.

    • 0
  2. Mike – Thanks for your help. I don’t know what I did, but, it is now working properly (and I see the curser changing to plus is correct). FYI – It occured on all sheets in that workbook, but, not in other workbooks. I have Office 2010. I had changed the color to red, green, and black – nothing.

    • 0