Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
prevent big white screen
hi all
I have complex excel sheet that does lots of calculations. It used to take 3 minutes to run. Now I use "Application.Calculation = xlCalculationManual" at the start and "Application.Calculation = xlCalculationAutomatic" at the end and it takes 30 seconds to run. The problem is, now while it is running a "total white screen" appears, as if it is not responding at all. But after it finishes running, it returns back to normal. Any ideas how to get rid of or hide the white screen? Thanks, sincerely jon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
prevent big white screen
Without seeing the code......hard to tell what the big white screen is but try
this. Application.ScreenUpDating = False 'do all the stuff Application.ScreenUpDating = True Gord Dibben MS Excel MVP On 29 May 2007 12:13:04 -0700, wrote: hi all I have complex excel sheet that does lots of calculations. It used to take 3 minutes to run. Now I use "Application.Calculation = xlCalculationManual" at the start and "Application.Calculation = xlCalculationAutomatic" at the end and it takes 30 seconds to run. The problem is, now while it is running a "total white screen" appears, as if it is not responding at all. But after it finishes running, it returns back to normal. Any ideas how to get rid of or hide the white screen? Thanks, sincerely jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lock a screen to prevent scrolling? | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
White screen in excel 2007 (beta 2) | Charts and Charting in Excel | |||
EXCEL workbook is off-white, goes white in edit mode | Excel Discussion (Misc queries) | |||
Colored cells are showing white on screen, want to see color? | Excel Discussion (Misc queries) |