Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

--

Dave Peterson

How do I check if the worksheet is protected... it may have inadvertently
been protected by a colleague.

multiple sheets were not selected... any other suggestions?

Thanks!!

"Dave Peterson" wrote:

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

--

Dave Peterson

When you click on Tools|Protection, do you see "Protect Sheet" or "Unprotect
sheet"?

You may notice that lots of icons on the standard and formatting toolbar are
disabled, too.

sorielly wrote:

How do I check if the worksheet is protected... it may have inadvertently
been protected by a colleague.

multiple sheets were not selected... any other suggestions?

Thanks!!

"Dave Peterson" wrote:

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

--

Dave Peterson


--

Dave Peterson

okay that doesn't seem to be the issue... any other suggestions?


"Dave Peterson" wrote:

When you click on Tools|Protection, do you see "Protect Sheet" or "Unprotect
sheet"?

You may notice that lots of icons on the standard and formatting toolbar are
disabled, too.

sorielly wrote:

How do I check if the worksheet is protected... it may have inadvertently
been protected by a colleague.

multiple sheets were not selected... any other suggestions?

Thanks!!

"Dave Peterson" wrote:

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

--

Dave Peterson


--

Dave Peterson

Do you see [Shared] in the titlebar?

If the workbook is shared, there are lots of features that are disabled.



sorielly wrote:

okay that doesn't seem to be the issue... any other suggestions?

"Dave Peterson" wrote:

When you click on Tools|Protection, do you see "Protect Sheet" or "Unprotect
sheet"?

You may notice that lots of icons on the standard and formatting toolbar are
disabled, too.

sorielly wrote:

How do I check if the worksheet is protected... it may have inadvertently
been protected by a colleague.

multiple sheets were not selected... any other suggestions?

Thanks!!

"Dave Peterson" wrote:

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

nothing in the title bar other than the name of the file...


"Dave Peterson" wrote:

Do you see [Shared] in the titlebar?

If the workbook is shared, there are lots of features that are disabled.



sorielly wrote:

okay that doesn't seem to be the issue... any other suggestions?

"Dave Peterson" wrote:

When you click on Tools|Protection, do you see "Protect Sheet" or "Unprotect
sheet"?

You may notice that lots of icons on the standard and formatting toolbar are
disabled, too.

sorielly wrote:

How do I check if the worksheet is protected... it may have inadvertently
been protected by a colleague.

multiple sheets were not selected... any other suggestions?

Thanks!!

"Dave Peterson" wrote:

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

I'm out of guesses--you got any further info to share?

sorielly wrote:

nothing in the title bar other than the name of the file...

"Dave Peterson" wrote:

Do you see [Shared] in the titlebar?

If the workbook is shared, there are lots of features that are disabled.



sorielly wrote:

okay that doesn't seem to be the issue... any other suggestions?

"Dave Peterson" wrote:

When you click on Tools|Protection, do you see "Protect Sheet" or "Unprotect
sheet"?

You may notice that lots of icons on the standard and formatting toolbar are
disabled, too.

sorielly wrote:

How do I check if the worksheet is protected... it may have inadvertently
been protected by a colleague.

multiple sheets were not selected... any other suggestions?

Thanks!!

"Dave Peterson" wrote:

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson