Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel bogs down when running my macros, what is causing it?
It doesn't happen in all workbooks. I have nearly identical workbooks and
some are slow to respond and process the macros, while others fly through in a couple of seconds. I thought it was size related when I 1st encountered the problem, but since I have had the problem on smaller workbooks. Setting the calculation to manual seems to help, but does not eliminate the problem. Looking for suggestions |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel bogs down when running my macros, what is causing it?
Location???
Fast server vs. Slow server??? -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "Rakmup" wrote: It doesn't happen in all workbooks. I have nearly identical workbooks and some are slow to respond and process the macros, while others fly through in a couple of seconds. I thought it was size related when I 1st encountered the problem, but since I have had the problem on smaller workbooks. Setting the calculation to manual seems to help, but does not eliminate the problem. Looking for suggestions |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel bogs down when running my macros, what is causing it?
I would think that it would depend a lot on what your macro does--if it
inserts/deletes rows or columns, then... (Saved from a previous post) Do you see the dotted lines that you get after you do a print or print preview? If you do Tools|Options|view tab|uncheck display page breaks does the run time go back to normal? Since you're changing columnwidths, excel could be figuring out where those dotted lines go. You may want to do something like: Option Explicit Sub testme() Dim CalcMode As Long Dim ViewMode As Long Application.ScreenUpdating = False CalcMode = Application.Calculation Application.Calculation = xlCalculationManual ViewMode = ActiveWindow.View ActiveWindow.View = xlNormalView ActiveSheet.DisplayPageBreaks = False 'do the work 'put things back to what they were Application.Calculation = CalcMode ActiveWindow.View = ViewMode End Sub Being in View|PageBreak Preview mode can slow macros down, too. Rakmup wrote: It doesn't happen in all workbooks. I have nearly identical workbooks and some are slow to respond and process the macros, while others fly through in a couple of seconds. I thought it was size related when I 1st encountered the problem, but since I have had the problem on smaller workbooks. Setting the calculation to manual seems to help, but does not eliminate the problem. Looking for suggestions -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running macros on ALL Excel tabs | Excel Worksheet Functions | |||
Anyone have troubles running 2003 macros in 2000 version of Excel | Excel Discussion (Misc queries) | |||
causing macros to run at insertion point | Excel Worksheet Functions | |||
Running macros when Excel starts up | Excel Discussion (Misc queries) | |||
Macros running slow in Excel 2003 | Excel Discussion (Misc queries) |