Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Start up problem (XL2002)

    I recently made changes by including some add-ins (which I have done before with no problem). However, after loading them this time whenever I start up Excel, after all the add-ins have been loaded, I get a message stating:

    "This workbook is currently referenced by another workbook and cannot be closed!"

    No error number, and once I click OK, then Excel works fine.

    Any suggestions on what causes this and what can be done to eliminate?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Start up problem (XL2002)

    Have you checked whether it might be one of the add-ins? Try unloading them one by one and reopening Excel - until the error message stops. For some reason, one of them may have become corrupted. HTH
    Gre

  3. #3
    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: Start up problem (XL2002)

    See Jan Karel <!profile=pieterse>pieterse<!/profile>'s Star <post#=186893>post 186893</post#>

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Start up problem (XL2002)

    Yes, I had taken all add-ins out and the problem persisted.

    After following Jan's post carefully, and still no results, I checked one final place (My Documents...ExcelXLStart as opposed to Program FilesOffice) and there was an extra file there with the name XLStart.xla. I removed it from the folder and no more problem.

    Thank you both for offering the advice and the process of detecting 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
  •