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?
Last Comment
dec0mpile
Update your graphic card driver. Get the latest one from the website of the system manufacturer.
Does the problem happen with all Excel files or just one?
ASKER
just one... I wonder that has anything to do with graphic card driver though..
Can you attach that Excel file?
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.
If the flickering is caused by macros, it would behave the same way on another computer.
ASKER
there is no macro... sorry I cannot attach the excel file due to company policy
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.
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.
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.
Or you can cut and paste the Workbook_Open code here and maybe we can see what's wrong.
ASKER
i really don't think it's the problem of excel file itself. I have tested on different computer and no flickering at all.
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.
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?
Does the computer that flickers use the same Anti-Virus as the one that doesn't?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
fond solution myself
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
