Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook open query
Hi all,
I have an Excel file that is 42.6 MB,it contains 50 worksheets, all of which are linked in someway to other worksheet/s ( within the same workbook ).When the workbook is opened the worksheet menu bar is removed and replaced by a new toolbar ( this is not an attached one ) it is activated via button click on the userform which is displayed when the workbook opens. My query is, how long should it take to open the file ? At the moment it takes approximately 1 minute, from clicking open file to the userform show. Is this time ok or should it be quicker ? Athlon xp 1800 - 1.53 Ghz many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook open query
Hard to give a definitive answer because many factors affect load time. How
long does it take to recalculate the workbook? That is part of the time, part is running your code (but this is probably minimal) - most is probably accessing the file from disk. Is the file local or networked? What is the speed of the disk? Has it been defragmented lately? How many other apps are on your system (BTW: my home computer takes forever to load VBA with Excel due to lots of other apps installed and a pretty fragmented disk) Given the size of the file, and if the book recalcs in a reasonable time, probably it is just the time to spend loading the file. -- - K Dales "labrev" wrote: Hi all, I have an Excel file that is 42.6 MB,it contains 50 worksheets, all of which are linked in someway to other worksheet/s ( within the same workbook ).When the workbook is opened the worksheet menu bar is removed and replaced by a new toolbar ( this is not an attached one ) it is activated via button click on the userform which is displayed when the workbook opens. My query is, how long should it take to open the file ? At the moment it takes approximately 1 minute, from clicking open file to the userform show. Is this time ok or should it be quicker ? Athlon xp 1800 - 1.53 Ghz many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook open query
Did a defrag. got it down to 30 secs.
thanks "K Dales" wrote: Hard to give a definitive answer because many factors affect load time. How long does it take to recalculate the workbook? That is part of the time, part is running your code (but this is probably minimal) - most is probably accessing the file from disk. Is the file local or networked? What is the speed of the disk? Has it been defragmented lately? How many other apps are on your system (BTW: my home computer takes forever to load VBA with Excel due to lots of other apps installed and a pretty fragmented disk) Given the size of the file, and if the book recalcs in a reasonable time, probably it is just the time to spend loading the file. -- - K Dales "labrev" wrote: Hi all, I have an Excel file that is 42.6 MB,it contains 50 worksheets, all of which are linked in someway to other worksheet/s ( within the same workbook ).When the workbook is opened the worksheet menu bar is removed and replaced by a new toolbar ( this is not an attached one ) it is activated via button click on the userform which is displayed when the workbook opens. My query is, how long should it take to open the file ? At the moment it takes approximately 1 minute, from clicking open file to the userform show. Is this time ok or should it be quicker ? Athlon xp 1800 - 1.53 Ghz many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data query leaves datasource workbook open | Excel Discussion (Misc queries) | |||
Running a query from an open workbook | Excel Programming | |||
Workbook Open macro/& Pivot Table Calculated field query | Excel Programming | |||
Workbook Open macro/& Pivot Table Calculated field query | Excel Programming | |||
Workbook Open macro/& Pivot Table Calculated field query | Excel Programming |