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

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

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

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

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. *