Excel cells all display blank

Question

After some MS update my Office 365 Excel stopped working correctly.  All spread sheets don't display the values of any cells:

Notice the edit window displays "Weights" but the cell desplays blanks.  This is how it displays on another computer:

Answer 1

All the images I tried to uploaded didn't work.  Attached are the screen shots of current display of spread sheet

This is what it looks like correctly on another computer:

Suggestions welcome...

Answer 2

Please try these options one by one and check after each option.

1. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

To start in Safe Mode -

Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.

To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

2. Try repairing your office installation (Quick repair is good enough). Try repairing your Office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

https://support.office.com/en-us/article/Repair...

3. Many third party applications also cause the problem like Tuneup Utilities, Abby Finereader, Kaspersky & other Anti Viruses etc. If you want to know if some program is conflicting -

Boot your computer in Clean boot mode and then start the application. If it works successfully, then some program is conflicting with this.

Refer to the section - How to determine what is causing the problem after you do a clean boot.

Don't forget to do - Reset the computer to start normally after clean boot troubleshooting.

https://support.microsoft.com/en-us/help/929135...

4. Sometimes, this is caused due to application not being able to access the default printer. Close all office applications and change your default printer through Start > Devices and Printers to another printer. It may be some physical one or One Note or XPS or PDF or anything else. If this is the problem, then you will need to update your printer driver for default printer.

Do let me know if you have any more question or require further help. If above didn't work, I will supply more troubleshooting steps to solve this problem.

Answer 3

None of that worked, although what was displayed got changed to look like:

Something is weird in displaying stuff.  Word and other apps are working fine.

Answer 4

Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

Now open Excel and see if the problem disappears or not.

Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

Answer 5

Uninstall and reinstall of Office is the next option in your case.

Uninstall - https://support.office.com/en-us/article/Uninst...

Reinstall - https://support.office.com/en-us/article/Downlo...