Solved

Save and Save As greyed out

Posted on 2007-04-02
3
1,316 Views
Last Modified: 2012-05-05
When one of my users changes something on their toolbar the "save" and "save as" options become greyed out and I cannot figure out how to make them available again.  Any ideas?
0
Comment
Question by:tstech248
  • 2
3 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
Can you clarify what you mean by "changes something on their toolbar "? Do you mean that if they customise the toolbars, they cannot save anymore?
Regards,
Rory
0
 

Author Comment

by:tstech248
Comment Utility
They did not remember what they changed.  Sorry
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
Comment Utility
You could try this:
1. Right-click a toolbar and choose 'Customize...'
2. On the Toolbars tab, select the 'Worksheet Menu Bar' from the list and press the reset button.

Alternatively, close Excel, locate the .xlb file located in C:\documents and settings\username\application data\microsoft\excel and rename it to .old then restart Excel. Note that this directory is hidden by default, and that removing the .xlb file will remove *all* customisations that the users have made to their toolbars.

HTH
Rory
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 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

11 Experts available now in Live!

Get 1:1 Help Now