Avatar of okamon
okamon asked on

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?
Microsoft ExcelMicrosoft OfficeWindows 7

Avatar of undefined
Last Comment
okamon

8/22/2022 - Mon
dec0mpile

Update your graphic card driver. Get the latest one from the website of the system manufacturer.
Martin Liss

Does the problem happen with all Excel files or just one?
ASKER
okamon

just one... I wonder that has anything to do with graphic card driver though..
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Martin Liss

Can you attach that Excel file?
byundt

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.
ASKER
okamon

there is no macro... sorry I cannot attach the excel file due to company policy

macro
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
byundt

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.
Martin Liss

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.
Martin Liss

Or you can cut and paste the Workbook_Open code here and maybe we can see what's wrong.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
okamon

i really don't think it's the problem of excel file itself. I have tested on different computer and no flickering at all.
Martin Liss

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.
byundt

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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
okamon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
okamon

fond solution myself