Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 70
  • Last Modified:

Missing "Save as" in Excel ribbon.

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
nav2567
Asked:
nav2567
1 Solution
 
[ fanpages ]IT Services ConsultantCommented:
"A customer is not seeing the "Save As" in Excel - see attached."

Nothing is attached.
0
 
nav2567Author Commented:
0
 
Dustin SaundersDirector of OperationsCommented:
This article might help, it shows how to add 'Save As' to the quick access toolbar.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
nav2567Author Commented:
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
 
Glenn RayExcel VBA DeveloperCommented:
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
 
nav2567Author Commented:
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
 
SamIDRCCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now