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

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

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