Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2013
    Location
    Laren, The Netherlands
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2010: "can't find project or library"

    After restoring my PC (Win7/64 with both Excel 2010 and 2003), at least Excel 2010 behaves, saves settings, allows developer tab to show etc (my post of 16/1).
    However, when I try to open Excel 2010 spreadsheets (packed with macro's) it continues to give the message: "can't find....".
    I have tried to open as many references as I can, solver, name manger etc but no luck.

    Most suggestions on this and other fora will say: look at the checkbox with prefix "missing", but the problem
    is here: when the macro's start to open, and the errormessage shows, you are in some mode, "break" I believe, that does not allow to see which references are missing (VBA/tools/references are greyed out).
    So I am in a catch22 situation and the only option is to force Excel down via task manager.

    In excel 2003, when you transfer to another machine, you need to include also addins that were downloaded from the web, eg. namemanager (not included in Excel 2003) and findlinks.

    grateful any idea's

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    MB47,

    When you are dumped into Break mode click on the Run menu item and select Reset. This will then allow you to get to the References section.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    New Lounger
    Join Date
    Jan 2013
    Location
    Laren, The Netherlands
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks RetiredGeek, it works but don't know how! I must have added in the right add-ins!
    Will try to use it, if it happens again.

  4. #4
    New Lounger
    Join Date
    Jan 2013
    Location
    Laren, The Netherlands
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Retired geek, I had same problem again with another spreadsheet, apparently I did not load "name manager".
    However, resetting did not work, it then gives again the message: "can't find....". Any other ideas?

Tags for this Thread

Posting Permissions

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