Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Posts
    482
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Path to AddIn not Saved (Excel 2000)

    I have an Addin I use with a spreadsheet. Until recently, everything worked fine. I don't know what changed, but now, every time I open the spreadsheet, it asks me to navigate to the location of this AddIn.

    It is located in the default location for Addins (Cocuments and Settings(user name)Application DataMicrosoftAddIns).

    Any ideas why I have to specify the location each time?

    Thanks!!
    Troy

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

    Re: Path to AddIn not Saved (Excel 2000)

    Has anybody done anything to the Workbook_Open() event for the target workbook? HTH
    Gre

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Posts
    482
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Path to AddIn not Saved (Excel 2000)

    No. There is no code in the that event.

    Troy

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

    Re: Path to AddIn not Saved (Excel 2000)

    Try removing the addin file from the directory. Then start Excel and go to Tools Addins and uncheck the addin. Shut down Excel. Move the addin file back into the addin directory. Start Excel and go to Tools Addins and use Browse to add it back to the list and then check it.
    Legare Coleman

  5. #5
    4 Star Lounger
    Join Date
    Apr 2001
    Posts
    482
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Path to AddIn not Saved (Excel 2000)

    I tried that, but it did not fix the problem. But ruling that out led to the real solution.

    I found some explicit references to this added at the wrong location in a formula. I don't know why they were there. But removing that solved the problem.

    Thanks for all the help!!
    Troy

Posting Permissions

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