| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does action on one worksheet affect all worksheets?
When I delete or change information on one worksheet, it automatically makes
the same change to all the worksheets. It has not always done that, so what have I done to cause this change? How can I fix it? Thanks, Confused |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does action on one worksheet affect all worksheets?
Perhaps you have grouped all the worksheets together.
To ungroup them, right-click on a sheet tab and select Ungroup sheets. Hope this helps. Pete On May 21, 2:36*pm, Confused wrote: When I delete or change information on one worksheet, it automatically makes the same change to all the worksheets. *It has not always done that, so what have I done to cause this change? * How can I fix it? *Thanks, Confused |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does action on one worksheet affect all worksheets?
If they have been grouped for any length of time you probably have quite a mess
on your hands. Hope you have a good backup............not one with grouped sheets. Gord Dibben MS Excel MVP On Wed, 21 May 2008 06:45:28 -0700 (PDT), Pete_UK wrote: Perhaps you have grouped all the worksheets together. To ungroup them, right-click on a sheet tab and select Ungroup sheets. Hope this helps. Pete On May 21, 2:36*pm, Confused wrote: When I delete or change information on one worksheet, it automatically makes the same change to all the worksheets. *It has not always done that, so what have I done to cause this change? * How can I fix it? *Thanks, Confused |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does action on one worksheet affect all worksheets?
Thanks! I knew I had done something, but had forgotten about that function.
"Pete_UK" wrote: Perhaps you have grouped all the worksheets together. To ungroup them, right-click on a sheet tab and select Ungroup sheets. Hope this helps. Pete On May 21, 2:36 pm, Confused wrote: When I delete or change information on one worksheet, it automatically makes the same change to all the worksheets. It has not always done that, so what have I done to cause this change? How can I fix it? Thanks, Confused |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does action on one worksheet affect all worksheets?
You're welcome - thanks for feeding back.
Pete On May 22, 4:55*pm, Confused wrote: Thanks! *I knew I had done something, but had forgotten about that function. * |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Action Item Worksheet Creation | Excel Worksheet Functions | |||
| How do i make a change in one worksheet affect the others | Excel Worksheet Functions | |||
| Same action in different worksheets | Excel Discussion (Misc queries) | |||
| use central formula on many worksheets, central affect allsheets | Excel Worksheet Functions | |||
| Can I protect a range of worksheets in a book with one action? | Excel Worksheet Functions | |||
Linear Mode
