+ Reply to Thread
Results 1 to 2 of 2

MISSING REFERENCE: Troubleshooting

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    MISSING REFERENCE: Troubleshooting

    Hi,

    I received a workbook from work and on my machine it breaks due to Missing References (I see in this in the Tools/References and notice MISSING

    Pretty much the issue is what is occurring here...
    http://www.cpearson.com/excel/MissingReferences.aspx

    It's strange because when the code in the workbook is ran on the other persons computer (Not mine) it works fine.

    In order to fix these missing references is there anything I can figure out from there computer that will help me resolve the issue on mine?

    For example, if they have access to a particular drive/folder and I don't --I am guessing that would cause an error too?

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,301

    Re: MISSING REFERENCE: Troubleshooting

    Hi swade730,

    This happens when code is written using early binding and then everyone who will be using the workbook does not have the exact same version on Excel installed as the person who wrote the code.

    Though now onerous, your best bet is convert all instances of early binding to late binding when a workbook is being used by different people in different regions.

    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Missing reference in reference library???
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2013, 05:00 AM
  2. [SOLVED] Circular Reference Troubleshooting
    By thesonofdarwin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-28-2013, 01:32 AM
  3. Remove missing reference, update outlook reference
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2011, 08:35 PM
  4. Sheets Missing From Reference
    By chromics in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2009, 02:37 PM
  5. Missing reference in a named range
    By just66horns in forum Excel General
    Replies: 2
    Last Post: 01-31-2008, 09:09 PM
  6. VBA code to check for missing reference.
    By arrowone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2007, 04:16 AM
  7. [SOLVED] Missing Reference?
    By The parawon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2005, 10:06 AM
  8. [SOLVED] A missing reference, maybe?
    By The parawon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2005, 09:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1