-
November 12th, 2020, 11:41 AM
#1
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
-
November 12th, 2020, 12:14 PM
#2
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
-
Forum Rules
|
|