All icons on my insert and data tab is greyed out

[Lily]

I was attempting to create a pie chart and clicked the pie chart icon.
However, did not want it embedded in the same Work sheet, so I clicked on the
new work sheet tab. It did not work and somehow I must have triggered
something else and all icons on both my insert tab and data tab is greyed out.

[Shane Devenshire]

Hi,

It sounds like you were in 2007? In that case create the chart in the
spreadsheet and then right-click the border of the chart and choose Move
chart. choose the New Sheet option...

Regarding the grayed out items - you are in Group mode because more than one
tab is selected. Right-click any sheet tab and choose Ungroup Sheets.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

[jerem...@gmail.com]

YES!

[anandvelu...@gmail.com]

yes it is really working great !

[d.voka...@gmail.com]

Gr8 Thanks

[greva...@gmail.com]

Yes - thanks

[jaim...@gmail.com]

I am trying to open a new excel workbook but all menu items are greyed out. What could be causing the options to be locked down?

[aseko...@googlemail.com]

Yes

[aseko...@googlemail.com]

On Tuesday, 30 December 2008 21:33:34 UTC, Shane Devenshire wrote:
> Hi,
>
> It sounds like you were in 2007? In that case create the chart in the
> spreadsheet and then right-click the border of the chart and choose Move
> chart. choose the New Sheet option...
>
> Regarding the grayed out items - you are in Group mode because more than one
> tab is selected. Right-click any sheet tab and choose Ungroup Sheets.
>
> --
> If this helps, please click the Yes button

Yes

[anso...@gmail.com]

Hi,

There are mainly 5 reasons for insert button grayed out.
1.File is shared
2.File is Protected
3.Multiple sheet selected
4.Display Options disabled
5.Track changes enabled
More information is available on this website with how to check these and fix it: http://www.askeygeek.com/deselect-multiple-worksheets-to-enable-insert-button-on-the-developer-tab/

Hope this helps
Thanks,
Anson

[anso...@gmail.com]

Reference: http://www.askeygeek.com/reasonscauses-for-why-insert-button-is-greyed-out-on-the-developer-tab/

[peg.le...@gmail.com]

[adrian...@gmail.com]

Thanks! it really works :)