[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

MS Excel data from cells is duplicated in other worksheets

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

AndrewEckstromAuthor Commented:
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.
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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