Forum Discussion
Excel added a 2nd quick access toolbar and changed top portion of worksheet to gray
I have used my excel (MS Office 2016) for 5 years, no issues. This evening Excel presented very differently. Upon opening:
- The top portion of the worksheet (quick access toolbar and tab areas) was gray - it is normally green.
- The tab areas now have a light gray color and are outlined.
- There is a second quick access toolbar, which I am unable to remove.
- NOTE - I was able to change a small part of the top of the worksheet back to GREEN by selecting an office theme of "Colorful".
- However this did not resolve nor address the issue a of second quick access toolbar, why was there an unsolicited change, and returning my toolbar and tabs back to the normal way of presenting.
Any ideas what is going on?
ALSO, FOR REFERENCE - I include a snapshot of my MS Word ribbon and tabs etc. Though this is MS Word - this is the same style the Excel worksheet had.
Thank you,
Roy
Hi,
This helped me with the same issue in my Excel 2016:
1. Type and launch Regedit in the windows search window.
2. Go to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\ExperimentConfigs\ExternalFeatureOverrides\excel
3. In the parameter "Microsoft.Office.UXPlatform.FluentSVRefresh" change the value "true" to "false".
Good luck!
25 Replies
Customize the Quick Access Toolbar
What do you want to do?
Are you suggesting one of those instructions explain how to fix my problem? I cant see any answer there? I use office 365
Hi,
This helped me with the same issue in my Excel 2016:
1. Type and launch Regedit in the windows search window.
2. Go to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\ExperimentConfigs\ExternalFeatureOverrides\excel
3. In the parameter "Microsoft.Office.UXPlatform.FluentSVRefresh" change the value "true" to "false".
Good luck!
- Hi Maxim, although your suggestion does fix the "2nd toolbar", it also makes the Excel icon on the far left of the title disappear. As such, I come to the conclusion that the save icon outside the toolbar, isn't part of the toolbar itself but a glitch performed on the last update probably. My work Excel 365 isn't updated and doesn't have this issue. My home Excel 2016 though, is updated, and has this same behavior. Also no other Office app has this issue. Hopefully they'll fix it with the next update.
RESOLVED!!
WOW!!! That worked!!
Thank you Maxim!!
Bonus point question: Any idea how/why that setting was changed, or what was the underlying cause of this?
Bonus bonus point question: How did you know this?
High regard and many thanks,
RoyROYL57 By having the try new features toggle on.
- Like a charm! Thanks.
- FYI - I tried the fix (did not work - no change) noted at:
https://docs.microsoft.com/en-us/answers/questions/493188/excel-2019-ribbon-updated-to-the-new-office-365-st.html
Control Panel > Apps and Features (found in the "Find a setting box"). > Apps and Features, find the Office 2016 and right-click it, perform an Online Repair for it.Try
File - options - General - Personalise your copy of Microsoft Office - Office Background - No background - Office Theme - Colorful. Got me back to green theme in Excel. The colourless title bar was making it hard for me to focus.
Frank
In Excel 2016, do the following:
Open / click "File"
Click on "Options"
New window will appear
Click on the link above on "General"
Right go to heading (Bold) with "Personalize Microsoft Office Copy".
Office design: change from white to bundle with the drop down menu (click on the small file below)
Press "OK" ... should be green again :).Hope I could help you with these information / links.
NikolinoDE
I know I don't know anything (Socrates)
* As a member of this community I provide help for self-help without guarantee.
the same thing has happened to me. Now got x2 quick access toolbars...in top left have Green excel icon and save file icon followed by vertical line...then my old quick access toolbar (new, open open, save etc):
Customize the Quick Access Toolbar
The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.
What do you want to do?
Add a command to the Quick Access Toolbar that isn’t on the ribbon
Change the order of the commands on the Quick Access Toolbar
Group the commands by adding a separator between the commands
Customize the Quick Access Toolbar by using the Options command
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Thank you NikolinDE,
Unfortunately I do not have an Office Design drop down. I did change "Office Theme" to "Colorful", which put some green back at the top of the worksheet.
However, I still have two different quick access toolbars, and the "not normal" looking tabs.
Can you suggest additional fixes?
Thank you,
RoyI guess under Office Design NikolinoDE meant both Office Background and Office Theme tabs. Office Design doesn't exists. However, above settings are applied to all Office app, not separately to specific app like Excel or Word.
Did you try in safe mode (Win+R -> excel /safe), do you have different colors for Excel and Word in it as well?
Hi! I have the same problem as @ROYL57. Unfortunately, the solution you proposed does not work for me since I can´t see the "Office Design" drop-down menu, nor the "bundle" option on any other menu, under the header "Personalize your copy of Microsoft Office".
Any thoughts?
Thanks in advance.
