I think this [Group] is causing me problems as all of the Data ribbon is
grayed out. How can I remove this [Group] designation next to the file name
at the top of the screen?

Thanks

To troubleshoot the issue with the grayed out Data ribbon, you can try the following:

1. Check if the workbook is in Compatibility Mode. If it is, save the workbook in the current Excel format to enable all features.
2. Make sure that the workbook is not protected. If it is, unprotect the workbook to enable all features.
3. Check if the workbook has any add-ins that may be causing the issue. Try disabling the add-ins and see if the Data ribbon becomes active.
4. If none of the above solutions work, try repairing or reinstalling Microsoft Office.

I hope this helps! Let me know if you have any further questions.

Right click a sheet tab and select ungroup


--
Regards,

Peo Sjoblom



"Lightjag" wrote in message
...
I think this [Group] is causing me problems as all of the Data ribbon is
grayed out. How can I remove this [Group] designation next to the file
name
at the top of the screen?

Thanks

Carefully check all the sheets that were "grouped".

What you have done to one sheet will have been done to all.


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 11:10:49 -0700, "Peo Sjoblom" wrote:

Right click a sheet tab and select ungroup