Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default data ribbon is greyed out

I would like to use features of the data ribbon for my spreadsheet. However,
the entire ribbon is greyed out. I must have done something. I only have this
problem with this workbook.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default data ribbon is greyed out

Hi,

check to make sure you are not in Group mode - look at the Excel title bar
and see if you see [Group]. If you do then you have more than one sheet
selected and virtually nothing on the Data ribbon can be used against
multiple sheets. Right click the sheet tab and choose Ungroup sheets.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Northwoods" wrote:

I would like to use features of the data ribbon for my spreadsheet. However,
the entire ribbon is greyed out. I must have done something. I only have this
problem with this workbook.

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
Data Validation Menu Greyed Out? TomP Excel Discussion (Misc queries) 6 April 3rd 23 07:48 PM
Why the data validation button is greyed out when it is in trackchange mode in Excel 2007 shan.shan.fu@gmail.com Excel Discussion (Misc queries) 0 May 16th 08 03:52 AM
Can we modify any of the ribbon tabs or create new ribbon tabs? Scott Sornberger New Users to Excel 2 March 19th 08 12:41 PM
When excel is opened, Insert, Format, Data options greyed out. j Excel Discussion (Misc queries) 2 September 23rd 06 02:30 PM
import data greyed out when protection enabled Robert Excel Discussion (Misc queries) 3 February 26th 06 10:30 PM


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

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

About Us

"It's about Microsoft Excel"