I’m trying to enter a function, which evaluates other columns and concatenates text. While testing it, I’m getting weird “overstrike” display. Instead of updating the cell, it’s overwriting the cell, so I can see the previous results behind the new results.
The function is ugly and gnarly, but it ought to work. In fact, it does work! When I refresh my computer screen – say, minimize it and then restore it – the display looks exactly right. But when I make a change in one of the contributing fields, the previous result doesn’t go away, but is overwritten.
Another thing: the sheet I’m working on is fairly big: 900 rows of 30 columns. When I do exactly the same function on a new, small sheet – one row of the same 30 columns – the screen refreshes quickly and normally.
Is it usual for Excel 2010 to overwrite data in cells after data change for big ugly sheets?