Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file name with [Group] at the end
Hi, a normal excel file suddenly aquired [Group] at the end of the file name
and various cells have become associated from sheet to sheet. I have never seen or heard of this particualr feature before and have created it accidently. Having achieved this I can't get rid of it. The effect is that when I update a cell on one sheet it updates some cells with the same data on another sheet, quite unwanted by me. I normally acheive this same effect using a formula (when I want to!) which is easy to detect and delete. I can't see what I have changed in the cell to undo this [Group] link. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file name with [Group] at the end
Look at the sheet tabs at the bottom of the screen.
Rightclick on one of the grouped sheets and and select Ungroup Sheets. Almost any changes you make to a sheet's that grouped with others is made to the other sheets in that group. You may want to inspect your data looking for problems. Grouping sheets is a nice way to update common cells (headers???). But it can be dangerous if you don't ungroup those sheets when you're done. KarenI wrote: Hi, a normal excel file suddenly aquired [Group] at the end of the file name and various cells have become associated from sheet to sheet. I have never seen or heard of this particualr feature before and have created it accidently. Having achieved this I can't get rid of it. The effect is that when I update a cell on one sheet it updates some cells with the same data on another sheet, quite unwanted by me. I normally acheive this same effect using a formula (when I want to!) which is easy to detect and delete. I can't see what I have changed in the cell to undo this [Group] link. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file name with [Group] at the end
Your sheets are grouped together. You can tell this because the sheet tabs
are shaded white. Right click on a tab, select ungroup sheets. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "KarenI" wrote: Hi, a normal excel file suddenly aquired [Group] at the end of the file name and various cells have become associated from sheet to sheet. I have never seen or heard of this particualr feature before and have created it accidently. Having achieved this I can't get rid of it. The effect is that when I update a cell on one sheet it updates some cells with the same data on another sheet, quite unwanted by me. I normally acheive this same effect using a formula (when I want to!) which is easy to detect and delete. I can't see what I have changed in the cell to undo this [Group] link. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Changing data in .csv file | Excel Discussion (Misc queries) | |||
Need to Query Excel File Opened by Another User | Excel Discussion (Misc queries) | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) |