Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 28
Default All icons on my insert and data tab is greyed out

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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,346
Default All icons on my insert and data tab is greyed out

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


"Lily" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default All icons on my insert and data tab is greyed out

On Tuesday, December 30, 2008 3:30:27 PM UTC-5, Lily wrote:
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.


YES!
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default All icons on my insert and data tab is greyed out

yes it is really working great !
  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default All icons on my insert and data tab is greyed out

Gr8 Thanks


  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default All icons on my insert and data tab is greyed out

Yes - thanks

  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default All icons on my insert and data tab is greyed out

On Tuesday, December 30, 2008 at 3:30:27 PM UTC-5, Lily wrote:
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.


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?
  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default All icons on my insert and data tab is greyed out

On Tuesday, 30 December 2008 20:30:27 UTC, Lily wrote:
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.


Yes
  #9   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default All icons on my insert and data tab is greyed out

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

Cheers,
Shane Devenshire


"Lily" wrote:

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.


  #10   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default All icons on my insert and data tab is greyed out

On Wednesday, December 31, 2008 at 2:00:27 AM UTC+5:30, Lily wrote:
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.


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-mu...developer-tab/

Hope this helps
Thanks,
Anson



  #11   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default All icons on my insert and data tab is greyed out

On Saturday, July 22, 2017 at 11:46:06 PM UTC+5:30, wrote:
On Wednesday, December 31, 2008 at 2:00:27 AM UTC+5:30, Lily wrote:
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.


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-mu...developer-tab/

Hope this helps
Thanks,
Anson


Reference: http://www.askeygeek.com/reasonscaus...developer-tab/
  #12   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default All icons on my insert and data tab is greyed out

On Tuesday, December 30, 2008 at 2:33:34 PM UTC-7, 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

Cheers,
Shane Devenshire


"Lily" wrote:

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.


  #13   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default All icons on my insert and data tab is greyed out

Thanks! it really works :)
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
My Insert Charts Buttons Are Greyed Out...Please Help [email protected] Charts and Charting in Excel 1 June 20th 08 04:49 PM
When excel is opened, Insert, Format, Data options greyed out. j Excel Discussion (Misc queries) 2 September 23rd 06 01:30 PM
Insert new worksheet option is greyed out. Why? Mags Tio Excel Discussion (Misc queries) 2 May 8th 06 02:10 PM
Insert Rows option greyed out Markus Excel Discussion (Misc queries) 0 February 15th 06 03:54 AM
Why is the menu item "Insert - Name" greyed out? Chuck Excel Discussion (Misc queries) 2 March 7th 05 05:25 PM


All times are GMT +1. The time now is 01:35 PM.

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

About Us

"It's about Microsoft Excel"