Excel 2010 flickers screen

when I open a excel file, my screen starts flickering. I did office repair but didn't help. I tried to open the same file on other computer, no issue... what could be the problem?
okamonAsked:
Who is Participating?
 
okamonAuthor Commented:
not sure why but after I changed the view to Normal, it stopped flickering.
0
 
dec0mpileCommented:
Update your graphic card driver. Get the latest one from the website of the system manufacturer.
0
 
Martin LissOlder than dirtCommented:
Does the problem happen with all Excel files or just one?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
okamonAuthor Commented:
just one... I wonder that has anything to do with graphic card driver though..
0
 
Martin LissOlder than dirtCommented:
Can you attach that Excel file?
0
 
byundtCommented:
Does the file that flickers contain macros? A Workbook_Open sub could be causing the flickering.

If the flickering is caused by macros, it would behave the same way on another computer.
0
 
okamonAuthor Commented:
there is no macro... sorry I cannot attach the excel file due to company policy

macro
0
 
byundtCommented:
A Workbook_Open sub won't appear in the Macro Selector dialog, so you still aren't able to dismiss that possibility.

To eliminate macros as a potential cause of the problem:
1.  Save the file as .xlsx file format. This will remove any and all macros from the saved copy.
2.  Quit Excel
3.  Relaunch Excel and open the .xlsx file. If it doesn't flicker, then macros in the original file are the cause.
0
 
Martin LissOlder than dirtCommented:
Another thing you can try is to type Alt+F11 or click the Visual Basic button. You'll then be in the development view. Find 'ThisWorkbook' on the left and double-click it. In the code find 'Private Sub Workbook_Open()' and click in the left-hand margin of that sub. Click somewhere in the sub and then press F5 which will start the process that the workbook goes through when it opens. From there repeatedly click F8 to see, line-by-line, where the code is going. I suspect it's in a loop.
0
 
Martin LissOlder than dirtCommented:
Or you can cut and paste the Workbook_Open code here and maybe we can see what's wrong.
0
 
okamonAuthor Commented:
i really don't think it's the problem of excel file itself. I have tested on different computer and no flickering at all.
0
 
Martin LissOlder than dirtCommented:
If it flickers for one Excel file but not for others then I'd put money on there being something in the one Excel file that's causing the problem.
0
 
byundtCommented:
Does the file have external links that need to be refreshed?
Does the computer that flickers use the same Anti-Virus as the one that doesn't?
0
 
okamonAuthor Commented:
fond solution myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.