+ Reply to Thread
Results 1 to 4 of 4

Why other worksheets changed when I change the value on in the cell on one worksheet?

  1. #1
    Registered User
    Join Date
    12-06-2010
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    45

    Why other worksheets changed when I change the value on in the cell on one worksheet?

    I have a workbook that has many different worksheets. I have never had problem enter data to these worksheets until this morning. For example, I enter -42 in a cell B1 on worksheet A, then all other cell B1 on other worksheets changed to -42. I did not format the worksheet at all. Can someone help me to fix this problem? Thanks.
    Last edited by ypurcaro; 10-16-2013 at 01:01 PM. Reason: Need to edit the title

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: Why other worksheets changed when I change the value on in the cell on one worksheet?

    You may have accidentally grouped the sheets together - when in this state, anything that you do on one sheet will be reflected on all the grouped sheets. To undo the grouping, right click on a sheet tab and select Ungroup sheets (or you can just click on a sheet tab that has not been grouped - the colour of the tab is different). You can group sheets together by holding down the SHIFT key and then clicking on another sheet tab, so you could easily have done this by accident.

    If you have not saved the file then you can get back to where you started from by closing the current file and then re-opening it, or you might have to click Undo a few times to get back to where you were.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-06-2010
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Why other worksheets changed when I change the value on in the cell on one worksheet?

    Thank you very much, Pete! It works!!!!! I'm so happyyyyyyyyy

    Thanks again for your help.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: Why other worksheets changed when I change the value on in the cell on one worksheet?

    Glad to hear it.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Wrong coding or RANDBETWEEN is wrong?
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-31-2013, 10:01 AM
  2. What's gone wrong with this one?
    By BCB in forum Excel General
    Replies: 10
    Last Post: 10-04-2006, 10:55 PM
  3. wHAT AM i DOING wrong
    By DMB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 01:41 PM
  4. What is wrong with this?
    By Conan Kelly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2005, 10:30 PM
  5. What is wrong?
    By Andy Dorph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1