Cell data disappears after scrolling the screen

eastermoai

New Member
Joined
Mar 10, 2009
Messages
2
Hi guys,

I have this excel file with 4000 or so rows. When i scroll the screen up and down data in some cells disappears. But when I click the cell the data shows up again. This happen if I click the cell with data validation pull down menu. But also for cells without pulldown menus. In these cells if I drag them or change the format they reappear. So the data is there but it fails to show. I also click ctrl+z sometimes, then all the value or text in the cells appear.

the file is running on excel 2007 with .xls compatibility mode. it seems it's refreshing problem, i.e. video card, etc. But the thing is the way the cells appears blank is in consistent. The portion appears like lego figures, i.e. random. FYI, there are two conditional formatting applied to the sheet. I disabled it but the problem persists.

I tried copying the entire sheet to a new book but the option is greyed out. There are atbalean.xla, etc installed and some macro form but password protected.

The way the problem manifest is random. Sometimes I can be scrolling up and down 20min incessantly till it happens.

I convert it to .xlsx and so far it seems the problem is gone but im not sure.

Any ideas or way to fix it?

Thanks guys.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
well, memory is not the issue. I take it that you also have a recent CPU. The only thing left is the video board.
 

Forum statistics

Threads
1,141,045
Messages
5,703,922
Members
421,321
Latest member
blusky4

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top