[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

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.
0
BoltonWanderer
Asked:
BoltonWanderer
1 Solution
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now