Excel Spreadsheets display nothing, not even grid lines
Results 1 to 2 of 2

Thread: Excel Spreadsheets display nothing, not even grid lines

  1. #1
    Join Date
    Jun 2000
    Location
    California
    Posts
    3,880

    Excel Spreadsheets display nothing, not even grid lines

    Windows 10, Office 2016. Excel spreadsheets with data in them show nothing except the menu ribbon. I've tried the following:
    • Disabled hardware acceleration
    • Turned off Add-ins
    • Cleared the Ignore apps that use DDE
    • Reset file associations

    Nothing works.

    Thanks - rev

  2. #2
    Join Date
    Feb 2000
    Location
    Idaho Falls, Idaho, USA
    Posts
    16,955
    I have seen that issue. For the computers where I have seen it, it is due to a font issue. Below are the commands that can be put into a batch file that we used to fix the problem:

    Note:
    This is assuming that you can create a new Excel spreadsheet, save it, and then load it again and see the text, but previously saved spreadsheets load and show up as blank. This is also on a Windows 10 system. Windows XP or 7 should not have this problem. The problem is due to Microsoft messing with the standard fonts on Windows 10.

    Code:
    @echo
    
    ::Powershell script for Arial font
    Powershell -command "Get-acl C:\Windows\fonts\arial.ttf | Set-Acl -path c:\windows\fonts\*.*"
    Powershell -command "Get-acl C:\Windows\fonts\arial.ttf | Set-Acl -path c:\windows\fonts"
    
    :: Take Ownership of the Font folder and internal files
    Attrib -r -s "c:\windows\fonts"
    takeown /f "C:\windows\fonts"
    icacls "C:\windows\fonts" /t /grant "authenticated users":(OI)(CI)F
    
    :: Stop and disable "Windows Font Cache Service" service
    :: FontCache
    sc stop "FontCache"
    sc config "FontCache" start=disabled
    sc query FontCache | findstr /I /C:"STOPPED" 
    if not %errorlevel%==0 (goto FontCache)
    
    
    :: Grant access rights to current user for "%WinDir%\ServiceProfiles\LocalService" folder and contents
    icacls "%WinDir%\ServiceProfiles\LocalService" /grant "%UserName%":F /C /T /Q
    
    
    :: Delete font cache
    del /A /F /Q "%WinDir%\ServiceProfiles\LocalService\AppData\Local\FontCache\*FontCache*"
    
    del /A /F /Q "%WinDir%\System32\FNTCACHE.DAT"
    
    
    :: Enable and start "Windows Font Cache Service" service
    sc config "FontCache" start=auto
    sc start "FontCache"
    Note:
    Before running these commands, make sure you have a backup of your system, in case something goes wrong.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •