Why are my excel popup windows transparent?

Anonymous
2022-12-03T13:37:24+00:00

For some reason, popup windows requiring dialogue are transparent, e.g. "Hide/Unhide" worksheets in a workbook. Eventually they appear normal, but very annoying. Affects other popup boxes as well.

Microsoft 365 and Office | Excel | For business | 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

46 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-13T03:24:04+00:00

    Jeff Boutain,

    This is long-winded and may not help with your issue but may give you something to try like changing the size of the Object and see what moves, the stuff in the Sheet or the stuff in the Object that looks transparent.

    In testing what is happening, save the workbook to a new name [ xxxxxxxx_Test_01.xxxx ]
    In the newly saved Workbook, click on the SHEET that is having the issue.

    Then go to the Review Menu and see if these two are seen.
    "Protect Sheet" and" Protect Workbook" [ this indicates that both of these Protections have NOT applied.
    Click on each and get them as described above.
    I have seen where you need to "check, uncheck" or "uncheck, check" to get the setting to work.
    In very few instances this can happen, not just in Excel, depending on how the code is written.

    Click the upper left corner of the Sheet ( which should select every cell in the spreadsheet ).
    Then go to HOME Menu / Format Cells and click on the TAB PROTECTION.
    It's the place you make it a number, currency, etc.

    Uncheck BOTH Locked & Hidden Check Boxes.

    Click the OK button, then save the Workbook and Close the workbook.

    Then, open the workbook and see if the Issue is still there.

    I have a similar issue in Office 365 Excel on Windows 11 current updates.
    It only seems to happen when I Lock the TOP ROW in view.
    Then the bottom of the frozen cell shows through the Note I have made.

    The note background is not transparent but the "frozen row bottom grid line" might be On Top of the Note.
    What you see on the screen are layers of Objects and one Object may overlap another object and make it look transparent.

    You can add blank lines in the Note and change the hight of the row and see the Frozen grid line move up or down over the Top of the Note.

    Freeze Top Row...

    Have issue...

    This may help if people having the problem, try the above and see if they see the grid line.

    If so, it may be that the object they are using may Not be finished rendering until after its properties have been completed and the [Print Screen] may force a refresh of the Excel sheet to update all components.

    Was this answer helpful?

    0 comments