Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
j j is offline
external usenet poster
 
Posts: 128
Default When excel is opened, Insert, Format, Data options greyed out.

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 268
Default When excel is opened, Insert, Format, Data options greyed out.

I do not say this will work, but try the following:

Click on Tools|Customize, select Toolbars, scroll down to Worksheet Menu
Bar, untick it WITHOUT clicking on Close, and then tick it againWhether this
helps or not, then click on close

"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

  #3   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract MS Excel Data embedded in MS Word qualityprocess Excel Discussion (Misc queries) 0 April 20th 06 05:52 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 09:03 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
excel data label format special number characters (part 2) todd Excel Discussion (Misc queries) 1 May 4th 05 04:08 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"