Wont keep changes

[PauleyG]

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?

 

[SixSigmaGuy]

Do you have VBA code behind the workbook?

We do something similar to what you are doing and our workbooks are much
larger than 40K rows. We don't experience any of the problems you do. We
are currently on Excel 2007, but we did the same thing (less rows of course)
in Excel 2003 without the problems you describe.

If you have some code behind your workbooks, it could possibly be the
culprit. I'm guessing that you probably do have some code since you posted
in the programming newsgroup. If so, please share some of the code and
someone and/or I will look at it.

Good luck!