excel spreadsheet replicating data in other cells in error

Anonymous
2021-03-31T15:53:15+00:00

We add data regularly to a spreadsheet in teams

Data added to one cell will suddenly be replicated in other cells, sometimes in different columns - there is a bug i imagine but I need to know where/how to stop this happening as important data is being overwritten

The cell in PINK is where the data was written and soon afterwards the same data appeared in rows below

This is a filtered list to show all the overwritten entries - affected 74 entries all together

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Anonymous
    2021-03-31T16:46:55+00:00

    Hi

    My name is André. I am an independent consultant.

    Apparently, this is some formulation, or badly developed VBA, can you upload your spreadsheet somewhere so I can analyze it?

    I hope this information is useful for you. If you still have questions, answer here so I can continue helping you.

    André.

    0 comments No comments
  2. Anonymous
    2021-03-31T18:23:46+00:00

    This sheet it literally data only - no formulas at all

    0 comments No comments
  3. Anonymous
    2021-03-31T18:26:43+00:00

    in this case, I really cannot help, at least I never experienced, something in that sense.

    Unfortunately I ran out of ideas to resolve this case, I will release the issue so that someone else can help you. good luck.

    0 comments No comments
  4. Anonymous
    2021-03-31T19:17:50+00:00

    Hi Luisa,

    I'm Gustavo, an independent advisor. I'll be glad to help you.

    Try the steps below on how you can repair Office.

    1. Open Control Panel > Programs
    2. Click Programs and Features
    3. Right-click Microsoft Office
    4. Choose "Modify" > and click "Yes"
    5. Choose the Online Repair
    6. Click "Repair"
    7. Restart your computer

    Please let me know if I helped.

    Best regards.

    0 comments No comments