Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB V's Excel
Hi The spreadsheet has grown to 10MB.The project has 20+ worksheets that calculate many formulas and graphs.The only way to speed up the calculations was to change back to excel; as the more VB code the slower the project. Is there a way to use VB and not slow down the project? pd -- pcd ------------------------------------------------------------------------ pcd's Profile: http://www.excelforum.com/member.php...o&userid=29557 View this thread: http://www.excelforum.com/showthread...hreadid=492595 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB V's Excel
Hi P,
Knowing nothing of your code it is very difficult to help, but arranging your code as follows may help: On Error GoTo XIT With Application CalcMode = .Calculation .Calculation = xlCalculationManual .ScreenUpdating = False End With ActivesheetDisplayPageBreaks = False 'Your code XIT: With Application .Calculation = CalcMode .ScreenUpdating = True End With --- Regards, Norman "pcd" wrote in message ... Hi The spreadsheet has grown to 10MB.The project has 20+ worksheets that calculate many formulas and graphs.The only way to speed up the calculations was to change back to excel; as the more VB code the slower the project. Is there a way to use VB and not slow down the project? pd -- pcd ------------------------------------------------------------------------ pcd's Profile: http://www.excelforum.com/member.php...o&userid=29557 View this thread: http://www.excelforum.com/showthread...hreadid=492595 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB V's Excel
The vb code should speed things up.
The problem may occur with too many formulas calculating values that never change. Change the formulas to values. Assign a macro (message box) to show what these values refer to if need be. don't use cell colors or large font sizes if you are the only person to view it. Columns of colored cells just to make it "pretty" also adds to recalc of the sheet/workbook Alternatively, spread the sheets into 20 Workbooks and have anther workbook to "import data" when it is required, with links to the 20 workbooks. You need to specify what you do and why. Does anyone else see your work? You can email me at See my stuff at: http://www.geocities.com/excelmarksway - -Mark "pcd" wrote: Hi The spreadsheet has grown to 10MB.The project has 20+ worksheets that calculate many formulas and graphs.The only way to speed up the calculations was to change back to excel; as the more VB code the slower the project. Is there a way to use VB and not slow down the project? pd -- pcd ------------------------------------------------------------------------ pcd's Profile: http://www.excelforum.com/member.php...o&userid=29557 View this thread: http://www.excelforum.com/showthread...hreadid=492595 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |