Excel - Cells copy data from one cell onto another cell

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.
BoltonWandererAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

StephenJRCommented:
Can you post a sample workbook illustrating the problem? In the VBE have you checked the sheet modules?
0
Rory ArchibaldCommented:
Is it just one user having the problem?
0
BoltonWandererAuthor Commented:
Yes, but not sure if anyone else uses that spreadsheet.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Rory ArchibaldCommented:
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.
0
sah18Commented:
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):

http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx

Let us know if this helps or not.
0
Arno KosterCommented:
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)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Pramod KumarCommented:
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?
0
BoltonWandererAuthor Commented:
Cheers
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.