Excel - Cells copy data from one cell onto another cell

Posted on 2011-10-05
Last Modified: 2012-05-12
This happens on a few excel spreadsheets.
When data is entered on one sheet in a cell, it randomly enters that information onto another sheet in a complete random cell, its not like its the same cell just on a different sheet.
I have reinstalled office 2007, repaired it. But nothing works. Its still doing the same thing.
It happens for some cells, but not others, but when I try to enter new info in that cell it doesn't update the info.

I have checked for any VBA info or any macros but I can't find anything.

All help is welcomed on how to do this. For the moment, I have asked the user to copy the data into a new spreadsheet and see if it still does that.
Question by:BoltonWanderer
    LVL 24

    Expert Comment

    Can you post a sample workbook illustrating the problem? In the VBE have you checked the sheet modules?
    LVL 85

    Expert Comment

    by:Rory Archibald
    Is it just one user having the problem?

    Author Comment

    Yes, but not sure if anyone else uses that spreadsheet.
    LVL 85

    Expert Comment

    by:Rory Archibald
    Can you try with another user? Or have the user with the problem open Excel in Safe Mode (hold down Ctrl key while starting normally, and answer Yes to the prompt) and then try using the workbook and see if it still occurs. If not, it's probably an addin or other startup file.
    LVL 9

    Expert Comment

    Another possibility is that it's not the Excel software itself, but perhaps that the workbook has some corruption.  I'd suggest making a copy of the workbook (so that you still retain the original), then run the repair utility on the workbook itself.  Here are some instructions (specifically for 2007, the version you indicated you're using):

    Let us know if this helps or not.
    LVL 19

    Accepted Solution

    have you checked for macro code in the spreadsheet that you type the information in and in all possible used addins ?

    in general when you open excel and an empty spreadsheet is visible, press Alt-F11 to open the VBA editor and check all objects (sheet sections, thisworkbook sections, module sections, userform sections and class module sections)
    LVL 10

    Expert Comment

    by:Pramod Kumar
    make sure there is no any paste-link is being used.(cell-linked)
    To verify this: click on the target cell where data is automatic printing and see the address-bar if some formula is showing there?

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now