MS Excel data from cells is duplicated in other worksheets

Posted on 2011-04-21
Last Modified: 2012-05-11
I have a customer who is running Excel 2010 on Windows 7 Pro.  After about six months of using this computer an issue with an Excel workbook appeared.  In the workbook there are about fiteen worksheets for recording employee time.  Now all of the sudden time data entered in a cell on Jane Doe's worksheet is duplicated on John Doe's worksheet.  The problem is inconsistent also.  There are times when the cell data is not duplicated accross worksheets.  Another user who has Excel 2007 does not expereince the issue.  I upgraded the workbook to .xlsx format from .xls format to see if that would help and it did not solve the problem.  I am wondering if this issue is due to a bug in some update of Excel 2010 over the last month.  Any help would be greatly appricated.
Question by:AndrewEckstrom
    LVL 9

    Accepted Solution

    I am not aware of any bug of this kind....but its silly but it happened to me something like this.....I was selecting four tabs to print at one shot and then I forgot to unselect - so when I typed the value in tab 1 it duplicated on all the 4. Just make sure that multiple tabs are not selected. This is the only reason I can think of this kind of behavior unless it has any codes running behind it...


    Author Comment

    That might just be the answer.  My client mentioned that when she prints sometimes Excel shows multiple tabs selected.  I will need to take a look at the speadsheet and determine what selects multiple worksheets.  I will get back.
    LVL 24

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now