Posted 14 June 2011 - 01:16 PM
I have been using Excel 2010 for a few months now and have noticed a number of issues with it. Some of these I have identified and found others online that are having similar issues, and some of them I have not. I was wondering if anyone else has had any of these occur, and if so, if you have have any advice regarding how to resolve for the future.
My data is getting mildly corrupted. One of the most recurring issues is the cell height will sometimes magically change to the maximum (409.5) for one row only when opening a document. This is easily corrected, but then it will do it again on another different row some other time when opening the document. It doesn't happen every time, and it's on random rows. It doesn't really matter much, other than, first, it concerns me that this happening in general, second, if it were to happen to our users, I would be the one getting the call. Fortunately most of our PC's are still running previous versions of MS Office where this wasn't a problem.
Another thing that has happened a few times, and is more concerning, is that sometimes entire cells will open with nothing in them. Again, this isn't the whole document, but just one row. It appears that the row is blank, when it actually contains data. And again this will just magically happen when opening a document. Sooner or later I or one of our users is going to delete what appears to be a blank row and actually end up deleting important data. When I have noticed rows that are blank, I will save the document and close it. When I reopen the document, the blank row will now have the missing data in it again.
Anyone know why this is happening? I never had any problems with Excel 2003 or 2007. And I don't want to sound like a hater of MS products. I really do like MS Office, and Windows 7 as well. I just don't understand how this is randomly happening to my spreadsheets. It's annoying at best, and may corrupt my data at worst. And one day when the rest of our office switches from legacy Office suites to Office 2010, I'm going to be the one getting the call when this happens. It is so random that I can't make heads or tails as to what may be causing it.
I must not fear. Fear is the mind-killer. Fear is the little-death that brings total obliteration. I will face my fear. I will permit it ot pass over me and through me. And when it has gone past, I will turn the inner eye to see its path. Where the fear has gone there will be nothing. Only I will remain.