I am working on an excel spreadsheet shared by four people. We all have the
ability to go in, make changes, and save it. We have been working on it for
months and have had no issues until recently. We have been highlighting rows
different colors then scrolling down the page, when we return to our previous
spot the highlights are gone. We also noticed different colors that we are
not using popping up on the spreadsheet in random places with no rhyme or
reason. If we enter data into a cell it will save, but the color of the cell
won't. Our spreadsheet is over 40,000 rows and we use the colors to track
what progress has been made, it also makes the spreadsheet more user
friendly. Any ideas on what might be causing this?