Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Mar 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Where is it coming from? (Excel 97 sr2)

    I recently had my harddisk wiped and restored including re-installing MS Office and now every time Excel starts up it tries to load a certain workbook with macros that have no value to me and slow the workbooks I have developed for some unknown reason.

    Before anyone says "virus" I know what this mystery workbook is used for by other departments but it has no value in my job and as I said it interferes with my existing workbooks (BTW, no it is not security related either).

    I removed the actual workbook from the harddrive but now Excel wants to hunt for it every time the application is opened. I have nothing in my startup folder and no personal macros workbook at all so where is Excel getting the instruction to load this odd workbook ? <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Where is it coming from? (Excel 97 sr2)

    Have a look at , Tools, AddIns and check to see if the workbook is listed and if so make sure that it is unchecked. That shoul dremove it from the list and prevent Excel from trying to load it at start-up.

    Andrew C

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Where is it coming from? (Excel 97 sr2)

    You might try the following
    1. <LI>Perhaps you have custom toolbar buttons attached to macros. Toolbar customizations are stored in a file with extension .xlb in your Windows folder (WinNT for Windows NT). Its name is username8.xlb where username is your logon name, or Excel8.xlb if you don't use logon names on your PC. Try and see what happens if you move or rename this file and then start Excel.
      <LI>Excel has 2 potential startup locations:
      <UL><LI>The standard startup file location C:Program FilesMixrosoft OfficeOfficeXLStart (exact path depends on where you installed office).
      <LI>The path set in Tools/Options..., General tab, Alternate Startup File Location.
    Check whether the Alternate Startup path is set, and if so, whether there are any files in that location.[/list]If this doesn't help, post back.

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Oregon, USA
    Posts
    236
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is it coming from? (Excel 97 sr2)

    Also look for any *.xlw files. If someone saved a workspace with the file in it every time it opens XL looks for that file.

  5. #5
    Lounger
    Join Date
    Mar 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is it coming from? (Excel 97 sr2)

    Thank you Hans... It was an oddly named shortcut in the C:Program FilesMicrosoft OfficeOfficeXLStart directory that was causing the problem. Much appreciated!

Posting Permissions

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