Excel becomes slow
 

Whenever I tried to open or print Excel sheet , my PC becomes slow.

Hi Sami,
The reason is that when you print or use print preview, Excel has to calculate
where the page breaks are. You can speed up your Excel by turning off
page breaks preview.

turn off manually: Tools -- Options -- View -- (uncheck) Page Breaks,
turn off in VBA: ActiveSheet.DisplayPageBreaks = False

Page Breaks
http://www.mvps.org/dmcritchie/excel/pagebreaks.htm

slow response
http://www.mvps.org/dmcritchie/excel/excel.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sami" wrote in message ...
Whenever I tried to open or print Excel sheet , my PC becomes slow.