View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default When excel is opened, Insert, Format, Data options greyed out.

All of the options are greyed out--or just some?

If it's just some, then maybe the worksheet is protected??
(Tools|Protection|Unprotect worksheet)

Or maybe the workbook is Shared??
Look for [Shared] in the title bar.
(Tools|share workbook to toggle this setting)

If it's all the options under all those menu items, I'd try:
Tools|Customize|Toolbars tab|select Worksheet Menu Bar
and click Reset

You'll lose any customized changes you've made to that toolbar, but you can add
them back later.

j wrote:

When excel is opened, Insert, Format, Data options greyed out. Right click
menu does not work

Protection option also greyed out so not issue of worksheet protection

need advice on permanant solution to use excel effectively.

tried reinstalling with original cd. does not work.

thanks


--

Dave Peterson