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
|