Solved

Missing "Save as" in Excel ribbon.

Posted on 2016-07-18
9
31 Views
Last Modified: 2016-09-10
A customer is not seeing the "Save As" in Excel - see attached.  

How do I add it back?  

If I want to use Group Policy to add it back, what location should I look?

Thanks.
0
Comment
Question by:nav2567
9 Comments
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
"A customer is not seeing the "Save As" in Excel - see attached."

Nothing is attached.
0
 

Author Comment

by:nav2567
Comment Utility
0
 
LVL 12

Expert Comment

by:Dustin Saunders
Comment Utility
This article might help, it shows how to add 'Save As' to the quick access toolbar.
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:nav2567
Comment Utility
I can click the down arrow to launch the customer quick access toolbar and click more commands to add the "save as" button in the ribbon.  

I need to do this on 500 computers.  Anyone knows the group policy way?
0
 
LVL 27

Expert Comment

by:Glenn Ray
Comment Utility
No points, but this document may help you with modifying the group policy.

https://technet.microsoft.com/en-us/library/ee308297(v=office.14).aspx
0
 

Author Comment

by:nav2567
Comment Utility
That's not it, Glenn.  

At this point, I have tried export in Quick Access Toolbar and place the "Excel Customizations.exportedUI" file under "C:\users\%username%\AppData\Roaming\Microsoft\Office but it does not work.  

I have read https://msdn.microsoft.com/en-us/library/office/ee704589(v=office.14).aspx but not sure what to do next after I export the Quick Access Toolbar file - Excel Customizations.exportedUI.
0
 
LVL 7

Accepted Solution

by:
SamIDRC earned 500 total points
Comment Utility
The .exportUI is only used with the import/export dialogue. The QAT customizaton file is named "Excel.officeUI" and likely under

C:\Users\%username%\AppData\Local\Microsoft\Office

You can also customize the specific Excel file to always show this on the QAT bar.

Of course users can always use the File menu with Save As (one extra click).

  Best wishes.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Mapping Drives using Group policy preferences Are you still using old scripts to map your network drives if so this article will show you how to get away for old scripts and move toward Group Policy Preference for mapping them. First things f…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now