Why does action on one worksheet affect all worksheets?

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

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
 
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
 
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
 
Thanks! I knew I had done something, but had forgotten about that function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Absolute References and worksheets 0
Linking data from one worksheet to another... 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VLOOKUP formula for multiple worksheets 4
Relative worksheet reference for multiple worksheets in a workbook 5
Using a Master Worksheet 1
Copy data from one worksheet to another 4
excel 2003 worksheet 1

Back
Top