Excel cells flash on and off

[Jack-P-Winner]

I really do not know how to explain this but my data in the cells are flashes like on and off and I can not go in the cell to change any data. Has anyone ever experienced this before

 

[Luke M]

Hello again Jack!

Yes....but only when some maniac asked me to create flashing cells.
Is it a constant repeating flash, as if they are timed, or irregular, as if the screen is not updating properly due to CFs or some macro?

 

[bobhc]

some maniac asked me to

...Brilliant.

 

[Jack-P-Winner]

Luke,

The screen is not flashing , only the cells and constant. I can not change the formulas, I can remove the formulas and re-write but I can not click on the cell without it flashing

 

[Jack-P-Winner]

Here is video

https://app.box.com/s/wm5up0oqpx68blapegj0

 

[Mike H..]

Here is video

https://app.box.com/s/wm5up0oqpx68blapegj0

Why don't you attach the workbook to your question? Much better than an MP4.

 

[Jack-P-Winner]

Mike,

My files are almost 2 GIGS each I. Can provide a link but there HUGH and no way to make it smaller and guarantee I will still have the issue. I will try to reduce it

 

[Hui]

That isn't the Cell that is flashing that is the formula bar
I believe that happens during recalculations
If you have any macro's make sure that

Application.EnableEvents=False
Application.Screenupdating =False

is at the start of any modules

re-enable these at the end of the code

I would also set Calculation mode to Manual and see it that causes it to stop

 

[bobhc]

My files are almost 2 GIGS each

...not so long back that was the size of the hard drive, who do you work for with Excel files that large..IBM.


.

 

[Hui]

Early versions of MS Word used to have a Flashing Text font option.
Which made text on the page flash.

It was removed in Word 2007

 

[Jack-P-Winner]

Thanks Hui!!!