Workbook has [Group] at the end of teh file name when opened
 

The file name on the drive does not show tis [Group] but the workbook when
opened does as part of the header in the blue bar where the fi,e name for the
workbook sits??

My other workbooks that are similar in nature do not have the [Group] after
it.

Mike

Workbook has [Group] at the end of teh file name when opened
 

You have more than one sheet selected.

Look at the tabs on the bottom of the window. You'll see that at least a couple
are selected.

To ungroup them:
You can select a different sheet or you can rightclick on any of the grouped
sheets and choose Ungroup Sheets.

The good (and bad) thing about having grouped sheets is that almost any change
you make to one of the group, you make to all of the group.

You may want to check to see if anything was damaged in those other grouped
sheets.

MikeR-Oz wrote:

The file name on the drive does not show tis [Group] but the workbook when
opened does as part of the header in the blue bar where the fi,e name for the
workbook sits??

My other workbooks that are similar in nature do not have the [Group] after
it.

Mike

--

Dave Peterson

Workbook has [Group] at the end of teh file name when opened
 

Thanks Dave - That also helped me understand how to make a global change to
several worksheets in a workbook. I will be posting a Q on how to make a
global change over several workbooks which you may be able to help.

Cheers
MIke

"Dave Peterson" wrote:

You have more than one sheet selected.

Look at the tabs on the bottom of the window. You'll see that at least a couple
are selected.

To ungroup them:
You can select a different sheet or you can rightclick on any of the grouped
sheets and choose Ungroup Sheets.

The good (and bad) thing about having grouped sheets is that almost any change
you make to one of the group, you make to all of the group.

You may want to check to see if anything was damaged in those other grouped
sheets.

MikeR-Oz wrote:

The file name on the drive does not show tis [Group] but the workbook when
opened does as part of the header in the blue bar where the fi,e name for the
workbook sits??

My other workbooks that are similar in nature do not have the [Group] after
it.

Mike

--

Dave Peterson