Excel 2003: Stop Screen flickering

[g.haarish]

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.

 

[Mike Fogleman]

Have you tried setting the calculation mode to manual before the query and
back to auto afterwards?

Mike F

 

[haarish_vikaasa]

Have you tried setting the calculation mode to manual before the query and
back to auto afterwards?








- Show quoted text -

Hi Mike,

No I havent tried that, what will that do?