Forum Discussion

ymcan's avatar
ymcan
Copper Contributor
Feb 17, 2021

Strange black areas on Excel online

I am getting really strange black and blue areas covering up part of my spreadsheet when I open it in Excel on the web, it works fine on the desktop app. Any ideas what could be causing this? I first thought it was my monitor, but that works fine for everything else (you can still see the row numbers on the left hand side).

 

16 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    ymcan 

    Never seen such. Was your sheet coloured manually or by conditional formatting and is such effect in any browser you have?

  • acsconner's avatar
    acsconner
    Copper Contributor

    ymcan I wish I had an answer for you, but I'm just happy to see this isn't only happening to me! I've seen this on occasion for the past few weeks in Excel Online and can't figure out when/why it shows up or how to make it go away. Hoping for some answers here! I've checked settings and can't find anything that seems like it would trigger this issue.

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor

      acsconner 

       

      Anzeigeproblem - schwarze Felder in Excel

       

      Hallo,

       

      gehe bitte wie folgt vor:

       

      Methode 1:

      Deaktiviere bitte in Excel die COM-Add-Ins über Datei > Optionen > Add-Ins > COM-Add-Ins > Gehe zu und teste das Verhalten.

       

      Hilft dies nicht, deaktiviere bitte auch die Excel-Add-Ins über Datei > Optionen > Add-Ins > Excel-Add-Ins > Gehe zu und teste das Verhalten.

       

      Methode 2:

      Setze in Excel über Datei > Optionen > Erweitert > Anzeige den Haken bei Hardwaregrafikbeschleunigung deaktivieren und teste das Verhalten.

       

      Methode 3:

      1. Schließe alle Office-Anwendungen.

      2. Drücke auf deiner Tastatur die Tastenkombination Windows-Taste + R. Es öffnet sich das Dialogfenster Ausführen.

      3. Gib den Befehl control printers ein und klicke auf OK.

      4. Klicke mit der rechten Maustaste auf Microsoft XPS Document Writer und wähle Als Standarddrucker festlegen.

      5. Teste bitte das Verhalten von Excel.

       

      Methode 4:

      1. Schließe bitte alle Office Anwendungen.

      2. Drücke auf deiner Tastatur die Tastenkombination Windows-Taste + R. Es öffnet sich das Dialogfenster Ausführen.

      3. Gib den Befehl regedit ein und klicke auf OK. Es öffnet sich der Registrierungseditor.

      4. Navigiere bitte zu folgenden Pfaden und benenne dort jeweils den Ordner mit dem Namen Excel um zu Excel_1 (falls vorhanden und möglich):

       

      HKEY_CURRENT_USER\Software\Microsoft\Office\Excel

      HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Excel

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Excel

       

      5. Schließe bitte den Registrierungseditor und führe über die Systemsteuerung eine Office-Reparatur durch.

      6. Teste bitte das Verhalten.

       

      I would be happy to know if this info from link help.

       

      Nikolino

      I know I don't know anything (Socrates)

       

      * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

       

      • ymcan's avatar
        ymcan
        Copper Contributor

        NikolinoDE 

         

        My German is limited, however I had a look at option 1 & 2 (option 3 and 4 are not possible in my situation), however there is no 'Options' menu under 'Data' in Excel online. Are you sure the solution you sent refers to Excel online?

         

         

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    ymcan 

    Apply or remove cell borders on a worksheet Tips

    • The Borders button shows the most recently used border style. To apply that style, click the Borders button (not the arrow).

    • If you apply a border to a selected cell, the border is also applied to adjacent cells that share a bordered cell boundary. For example, if you apply a box border to enclose the range B1:C5, the cells D1:D5 will acquire a left border.

    • If you apply two different types of borders to a shared cell boundary, the most recently applied border is displayed.

    • A selected range of cells is formatted as a single block of cells. If you apply a right border to the range of cells B1:C5, the border is displayed only on the right edge of the cells C1:C5.

    • If you want to print the same border on cells that are separated by a page break, but the border appears on only one page, you can apply an inside border. This way, you can print a border at the bottom of the last row of one page and use the same border at the top of the first row on the next page. Do the following:

      1. Select the rows on both sides of the page break.

         

         

        I would be happy to know if I could help.

         

        Nikolino

        I know I don't know anything (Socrates)

Resources