View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
EricG EricG is offline
external usenet poster
 
Posts: 220
Default Many menu options are grayed-out

Is the workbook shared? You will see "[Shared]" in the Excel window title if
it is. When a workbook is shared, certain functions are disabled.

HTH,

Eric

"Eric_NY" wrote:

I've received an Excel file by email. I'm opening it in Excel 2003.

It seems like a normal sheet - a table of text data in six columns. But some
of the menu options are grayed-out. Here are the menu choices that are grayed
out:

On the Format menu: Conditional Formatting
On the Insert menu: Chart, Symbol, Diagram, Object, Hyperlink
On the Data menu: Subtotals, Validation, Table, and PivotTable

I can make changes to the sheet without problems, and I can't see anything
unusual about the sheet.

I can copy the table to another sheet, and there are no problems there. But
I'm still puzzled why some menu options are unavailable.

Any ideas why these menu options are unavailable?

Thanks.