Question Locked

Excel 2010 - blank cell but data show in formula bar

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi there, i am now facing this issue INTERMITTENT. Half way using excel certain cells of my sheet will go white. when i point to formula bar i can see the data. After i scrow up and down of the page, the data appear again in the cell.
Anyone can provide help?

thank you.

3 replies

by al kostiuk

This is likely a memory resource issue with your machine. If you have shared memory for CPU and graphics (many laptops do), a combination of the number of applications running, size of spreadsheet, number of calculation cells, etc. may cause the graphics memory allocation to be reduced and you can get display problems.

Another contributer might be the display zoom factor of the spreadsheet, if your sheet is other than 100% view scale, you may get display drop outs. Word also has this issue when editing large documents with complex formatting.

by jamesmondtan

Hi Al kostiuk,
sorry for late reply. The view scale is 100%. As for the memory sharing with cpu. How can i verify it.
thank you for your answer.

This discussion is closed to new replies.