Excel on Microsoft Teams randomly changing cell content, repeat number overwriting original number.

Bonnie Janes

New Member
Joined
Apr 27, 2017
Messages
26
Hi, I wonder if anyone has come across this very strange gremlin before. We have an Excel document on Microsoft Teams that only 2 people access, we have just noticed that one column has a number repeated over and over, this column has no formulas linked to it, it's just where I insert a figure, it does have conditional formatting on it, but that's all. I've just sat and changed all these numbers, all 64 of them, and gone back into it and noticed another number has appeared in several rows. I haven't changed or overwritten these cells and neither has my boss, so it's happened automatically. Any idea what could have caused this?
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,114,608
Messages
5,548,975
Members
410,887
Latest member
sjohn627
Top