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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,114,655
Messages
5,549,235
Members
410,905
Latest member
Extjel
Top