| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open workbook b when workbook a opened | Excel Discussion (Misc queries) | |||
| cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
| How to run a macro as soon a a workbook (.xls) is opened? | Excel Worksheet Functions | |||
| Workbook copies itself when opened | Excel Worksheet Functions | |||
| Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions | |||
Hybrid Mode
