ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Problem with Excel (https://www.excelbanter.com/setting-up-configuration-excel/121362-problem-excel.html)

Andy

Problem with Excel
 
Hi Everyone,

I am running Office XP. The problem I have is with Excel. When I open the
application some of the Icons are greyed out (open folder, undo, redo, copy
and paste, etc). Even when a document is open they are still greyed out.

I had this problem some time ago and a colleague of mine to me to go into
Tool and Option and to tick/untick a box and it worked. However I cannot
remember what this option was. Any ideas? I have tried everything I can
think of.

Many thanks.

Andy



Dave Peterson

Problem with Excel
 
Your colleague could have reset a toolbar or two. But that's not under
Tools|Options. It's under Tools|Customize.

Tools|Customize|toolbars tab
select each of the toolbars you want to reset and then click the reset button.

You can reset all the toolbars by doing this:
Close excel
windows start button|search
look for *.xlb
(Look in hidden folders for hidden files, too)

rename them all to *.xlbOLD

Restart excel to test it out.

If it worked, delete those *.xlbOLD files.

If not close excel and rename them back to *.xlb.

This will remove any customized changes from your toolbars.



Andy wrote:

Hi Everyone,

I am running Office XP. The problem I have is with Excel. When I open the
application some of the Icons are greyed out (open folder, undo, redo, copy
and paste, etc). Even when a document is open they are still greyed out.

I had this problem some time ago and a colleague of mine to me to go into
Tool and Option and to tick/untick a box and it worked. However I cannot
remember what this option was. Any ideas? I have tried everything I can
think of.

Many thanks.

Andy


--

Dave Peterson


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com