Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros i XL 2003 versus 2000 - speed problems
I run a report in Excel which collects data via ODBC from a Superbase database. Excel macros then edit data, format data, saves files in different formats and prints the report. The entire package has run for about a year in 14 minutes every day. After "upgrading" my PC to Windows XP and Office Professional 2003 it takes over an hour to run the report. The ODBC part is still OK but the macro part where a filter is applied and the remaining rows are to be deleted takes forever. Once it comes through, the final parts of saving and printing runs well. Does anyone know if Excel 2003 handles macros differently than 2000 did? Any hints on how to speed things up? Hopeful! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros i XL 2003 versus 2000 - speed problems
Ankan wrote:
The entire package has run for about a year in 14 minutes every day. After "upgrading" my PC to Windows XP and Office Professional 2003 it takes over an hour to run the report. Make sure that Tools / Options / Calculation is Manual (or in VBA: Application.Calculation = xlManual ) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup This message was posted by a volunteer directly to the Microsoft public newsgroups. For best results, connect to these newsgroups directly by clicking news://msnews.microsoft.com, or read the archives at http://groups.google.com. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros i XL 2003 versus 2000 - speed problems
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003/XP Macros in 2000 | Excel Worksheet Functions | |||
calculation speed of Excel 2003 and Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 versus 2003 and the TEXT Function | Excel Worksheet Functions | |||
where did my old 2000 Excel macros go when I upgraded to 2003? | Excel Discussion (Misc queries) | |||
Upgrading Problems: Excel from 2000 to 2003 | Excel Worksheet Functions |