Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Whenever I tried to open or print Excel sheet , my PC becomes slow.
|
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel formulas are slow to update | Excel Worksheet Functions | |||
Why are subtotals so slow in Excel 2002 SP-2? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Slow opening Excel Workbook with over 50 Worksheets | Excel Discussion (Misc queries) |