| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: Stop Screen flickering
Hi all
I have an excel report that has lots of reports onto its sheets. When the sheet i activated, the sheet immediately queries a database to retrieve values. Indoing so, the screen keeps flickering which the users find quite irritating. Application.screenupdating=False is not doing what I need. Any ideas? Many Thanks, Haarish. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2003: Stop Screen flickering
Have you tried setting the calculation mode to manual before the query and
back to auto afterwards? Mike F wrote in message ups.com... Hi all I have an excel report that has lots of reports onto its sheets. When the sheet i activated, the sheet immediately queries a database to retrieve values. Indoing so, the screen keeps flickering which the users find quite irritating. Application.screenupdating=False is not doing what I need. Any ideas? Many Thanks, Haarish. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2003: Stop Screen flickering
On Aug 25, 3:50 pm, "Mike Fogleman"
wrote: Have you tried setting the calculation mode to manual before the query and back to auto afterwards? Mike wrote in message ups.com... Hi all I have an excel report that has lots of reports onto its sheets. When the sheet i activated, the sheet immediately queries a database to retrieve values. Indoing so, the screen keeps flickering which the users find quite irritating. Application.screenupdating=False is not doing what I need. Any ideas? Many Thanks, Haarish.- Hide quoted text - - Show quoted text - Hi Mike, No I havent tried that, what will that do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blinking/flickering screen | Excel Discussion (Misc queries) | |||
| How to stop flickering chart during macro run | Excel Discussion (Misc queries) | |||
| FLICKERING SCREEN WHEN WORKING | Excel Discussion (Misc queries) | |||
| Flickering of the Screen when the Macro runs. | Excel Programming | |||
| Screen flickering when updating textboxes | Excel Programming | |||
Linear Mode
