Excel 2010 - blank cell but data show in formula bar

By jamesmondtan ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Intermittent data disappearing in Excel

by Al Kostiuk In reply to Excel 2010 - blank cell b ...

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.

Collapse -

Reponse To Answer

by jamesmondtan In reply to Intermittent data disappe ...

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.

Related Discussions

Related Forums