BoltonWanderer
asked on
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.
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.
StephenJR
Can you post a sample workbook illustrating the problem? In the VBE have you checked the sheet modules?
Is it just one user having the problem?
ASKER
Yes, but not sure if anyone else uses that spreadsheet.
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.
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.
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx
Let us know if this helps or not.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
To verify this: click on the target cell where data is automatic printing and see the address-bar if some formula is showing there?
ASKER
Cheers