Share via

Data missing in columns from AA and beyond.

Anonymous
2021-12-03T21:26:27+00:00

Data is not visible in cells from column AA and beyond. Same formula or manually entered data appears properly in earlier columns. I have looked for hidden columns, column width, width="", frozen columns and have gone through many other options found in forums. My column text heading does appear. My column data type is set to Number. One of my formulas is =MAX(E2-D2) .

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points
    2021-12-05T22:08:00+00:00

    Thanks. The font color of columns AA and AB from row 2 down has been set to white.

    Select columns AA and AB, then set the font color to Automatic (or to black).

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-12-04T17:09:53+00:00

    So sorry. It must be a security/privilege issue. It worked for me. I will try to fix the access issue this afternoon or evening. Thank you for trying to help me.

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2021-12-04T08:47:26+00:00

    I get a message that the file isn't available.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-12-04T01:14:23+00:00

    I think this link will get to the file:

    OptionsPL20210320 Share.xlsm - Microsoft Excel Online (live.com)

    See columns AA and AB for some sample info.

    Was this answer helpful?

    0 comments
  4. HansV 462.6K Reputation points
    2021-12-03T21:31:54+00:00

    Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

    By the way, the formula =MAX(E2-D2) is equivalent to =E2-D2

    Was this answer helpful?

    0 comments