Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Takes Forever to Launch (2000)

    Whenever I attempt to open an .xls workbook (or to launch Excel itself), Excel will take a lifetime to launch. The HD works like mad for about ten seconds and other applications will occasionally freeze for a few seconds until everything normalizes when Excel launches at last.

    Does anyone what might cause this behavior? I had a similar issue before and I realized that too many add-ins were opened on Excel startup, so I unchecked them all. Not even the Solver add-in left. That got the problem solved back then.
    What gets me real curious (rather anxious) is the high HD activity during the process... <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

    TIA
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel Takes Forever to Launch (2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Diegol

    What is the size, and how many forumlas and worksheets and graphs and what have you do you have in this workbook that are you using?

    How long has it since you did any maintenance (defraged the Hard drive) on your PC?

    What else is running besides MS-Excel at the time when you launch it?

    How much RAM do you have in your PC?

    How fast is your CPU?

    All sorts of questions need to be figured out before anyone can really give you an answer.

    Please try your best to tell us about your PC, what Windows you are running, and what hardware are you using.

    HTH

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    Hi Wassim,

    This behavior occurs both when I open a worksheet and when I start Excel from scratch (blank document), so it's not the number of formulae / images or other particular content in the document that triggers the annoyance.
    I tried closing all applications before starting Excel but to no avail, so the key is not there either.
    Rest of the data: Pent III 550 Mhz, 128 MB RAM, Win98. Free disk space: about 1 GB out of 20.

    As for the maintenance... I don't remember when I last ran a scandisk or a defrag... <img src=/S/blush.gif border=0 alt=blush width=15 height=15> I'll give that a try. The problem I described dates from about a year and I think I ran a defrag as soon as I stumbled upon it, however. But I'm not sure.
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel Takes Forever to Launch (2000)

    <img src=/S/bash.gif border=0 alt=bash width=35 height=39> Diegol

    Sorry but I don't want to be harsh, but keep your system in tip top shape, just as you like your car to be with gas, oiled, and ready to go... Oh you don't oil your car every so often <img src=/S/duck.gif border=0 alt=duck width=23 height=23>

    No just kidding, run your defrag, and then reboot and then see if there is any thing different. It might also be a bad file on your system, I mean its known to happen.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Takes Forever to Launch (2000)

    Have you tried the things in Jan's <post#=290455>post 290455</post#> which is a STARred post and currently listed at the top of the main page?

    Steve

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    Check to see what files you have in your XLStart directory. Excel will try to open all of the files in this directory. Also, select "Options..." from the Tools menu. Click on the "General" tab. See if there is a path entered into the "Alternate startup file location" text box. Excel will also try to open all of the files in this directory.
    Legare Coleman

  7. #7
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    Wassim, Steve, Legare:

    Thank you very much for your help. I've been away from my PC for 2 days (I mean... <big>2 DAYS!!!!</big>) so I couldn't answer earlier.

    Far as I've read, the StarPost Steve referred me to is awesome. A quick check yielded the following:
    - Run-> excel /automation (yup, no need to enter the full path with quotes nor the .exe extension) and Excel started smoothly like the charm it's supposed to be.
    - No Alternate Startup Location
    - BUT... in the XLStart folder I come to find PDFMaker.xla, which must be some template used by Acrobat for the PDF toolbar or something. So apparently the problem lies there.

    In 5 minutes I'll leave and will be away from my PC for (STILL ANOTHER!!!) 2 days. As soon as I can take a look at it I'll post back with the result.

    Again, thank you very much!!
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    Hi Diegol

    <hr>yup, no need to enter the full path with quotes nor the .exe extension<hr>
    The reason that the post states to use the full path, is that some people have trouble starting Excel without qualifying the full path.
    Using the full path and excel's application name ensures the system actually finds and launches Excel.

    When there are mutliple versions of Office installed (I have three...) this is particularly important, since otherwise one cannot be sure which version is started.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    We seem to get this complaint a lot at work (about Excel being slow to load), and we have entered this in our internal knowledge base as the best way to remedy:
    <hr>
    If a user is having trouble with an Excel file loading very slowly:

    May be because one or more of the .emf files are corrupted or the Temp folder may have too many files in it.

    Goto:
    C:WindowsTemp or
    Documents & SettingsusernameLocal SettingsTemp

    Delete:
    All .emf files
    All .tmp files
    <hr>

    Of course, I think most of this was covered in Jan's STAR post mentioned above. I was just amazed at how well this particular little trick worked on most PCs in our bank.

    Tracy
    (edited for mispelled word)

  10. #10
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    Hi Jan,

    First off, your post is a great step-by-step guide to tackle down Excel startup annoyances, and I didn't mean any offense. I just thought entering the command that way would work and... well, it saved me some time <img src=/S/smile.gif border=0 alt=smile width=15 height=15>.

    Secondly, to all the loungers that supported this lonely soul: I removed the PDFMaker.xla file from the XLStartup folder and that's it, Excel is running smoothly <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>. I won't miss the PDF Toolbar either, as I didn't even have it active. If ever I need to PDF an Excel file I'll do it from the Print menu.

    Thank you very much!
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  11. #11
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    Hi Tracy,

    Just curiosity, what kind of files are .emf?
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    .emf files are created by workbooks that have controls in them (dropdown, listbox, spinner, scrollbar, commandbutton). I guess they are put there, so next time Excel can load the file they belong to a bit faster. But they sometimes tend to get corrupted and then cause trouble opening the file they belong to. Also, since the .emf files are not cleaned up, they tend to start slowing down opening and closing of other files.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    Hi Jan,

    <hr>I guess they are put there<hr>
    From this and from Tracy's post, there means in the Temp folder?
    A long while ago I used some controls but I took them from the Forms toolbar and associated some macros to them. Should this have created .emf files too? I point out that I used the Forms toolbar because there are controls in the Controls Pane (Cuadro de Controles in Spanish) Toolbar also and I don't know if there's any difference..
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  14. #14
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    I'm not sure whether or not Forms toolbar controls do this too.

    Forms controls are simpler to use, but have less options than the control toolbox controls. The forms controls stem from good old Office 4 (Excel 5).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Takes Forever to Launch (2000)

    I just tested and discovered that adding a control toolbox control adds an emf file, where-as adding a forms control doesn't. Even changing the width of a toolbox control adds another emf. But when Excel is closed, they are (should be) removed. I guess when some crashes have occured, many emf's can remain.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •