Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application coded in excel 2000 when used in excel 2003 excel doesnot perform well and takes double the time to give the output
Hi All,
I have a strange issue. The application coded in excel 2000 is not performing nicely in excel 2003. I have gone through the folowing link: http://www.mvps.org/dmcritchie/excel....htm#excel2003 The steps like switching to calculation manual and then screen updating= false is taken care in my code. The functions like offset() and other volatile functions which are used is same for excel 2000 and excel 2003, then I fail to understand why it is taking more time. Even some of the links asked to install the drivers. I have application which I have coded in 2003 which are performing better but they are not taking care of much of reporting. I have gone throughn the following links: http://www.decisionmodels.com/calcsecretsc.htm http://groups.google.com/group/micro...ee7cd241b0a295 http://groups.google.co.uk/group/mic...+to+excel+2000 http://help.lockergnome.com/office/P...ict570863.html Please can some one judge the solution that what might be the problem in calculations of the same functions. I do understand it is a big application but what might or what settings might have changed that the same functions are taking double time. Please reply out of the box as I am in need of all my friends advice and expertise. Thanking all of you, Regards, Prince |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Programming | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel 2000 VBA Application on Excel 2003 | Excel Programming | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Why with Excel Xp takes time to open and in 2003 fast? | Excel Discussion (Misc queries) |