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...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Feb 22, 2021

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
Feb 22, 2021

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
    Feb 22, 2021

    ymcan 

    Same in english:

     

    Display problem - black fields in Excel

     

    Hi,

     

    please proceed as follows:

     

    Method 1:

    Please deactivate the COM add-ins in Excel via File> Options> Add-Ins> COM-Add-Ins> Go to and test the behavior.

     

    If this doesn't help, please also deactivate the Excel add-ins via File> Options> Add-Ins> Excel Add-Ins> Go to and test the behavior.

     

    Method 2:

     

    Set the check mark for Deactivate hardware graphics acceleration in Excel via File> Options> Advanced> Display and test the behavior.

     

    Method 3:

     

    1. Close all Office applications.
    2. Press the key combination Windows key + R on your keyboard. The Run dialog box opens.
    3. Enter the command control printers and click OK.
    4. Right-click Microsoft XPS Document Writer and choose Set as Default Printer.
    5. Please test the behavior of Excel.

     

     

    Method 4:

     

    1. Please close all Office applications.
    2. Press the key combination Windows key + R on your keyboard. The Run dialog box opens.
    3. Enter the command regedit and click OK. The registry editor opens.
    4. Please navigate to the following paths and rename the folder with the name Excel to Excel_1 (if available and possible):

     

    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

     

    1. Please close the registry editor and carry out an Office repair via the control panel.
    2. Please test the behavior.

     

    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.

     

Resources