Forum Discussion
Cindy_Pruett
Nov 02, 2021Copper Contributor
Excel Zoom slider greyed out and Customized Status Bar is blank
I needed to upgrade my old laptop since it was having problems. My employer sent me an identical system. They both run Windows (same version and OS patch levels). They both have Office 365 with iden...
- Nov 02, 2021I suspect you have an Excel add-in which is causing havoc. Open File, Options and click the add-ins tab. Click the Go... button. Note which add-ins are checked and uncheck them one at the time, each time closing the dialog and rebooting Excel and retrying to open a file. If it starts behaving you've found the problem add-in.
There are two types of add-ins, so repeat this process for File, Options, Add-ins tab, click the drop-down and choose "COM add-ins".
In addition, a file may be automatically loaded from two different locations.
1. File, Options, Advanced tab, General section there is a box that says "At startup, open all files in:", note what is there and clear it.
2. Close Excel and open Windows Explorer and type this in the address bar: %appdata%\Microsoft\Excel\XLSTART and hit Enter. Move all files from that location to somewhere else.
Now reboot Excel
JKPieterse
Nov 02, 2021Silver Contributor
The sum/average calculations can be reinstated by a right-click on the statusbar. Other than that, I have never heard of a connection between zoom level or the slider and the calculation settings. What happens when you open Excel in safe mode (press and hold the control key while you launch Excel for the first time, click Yes when prompted and then open one of those files)?