Cannot find #REF!#REF error

Discussion in 'Excel Errors' started by PJFry, May 27, 2009.

  1. PJFry

    PJFry Guest

    I am running Excel 2007 on XP Pro.

    When I open certain workbooks, I get the following error:
    'Cannot find #REF!#REF, which has been assigned to run each time [Filename]
    is opened. Continuing could cause errors. Cancel opening [Filename]?'

    I have copied the worksheets into a new workbook, but the error follows.
    There no errors in my formulas to trace this back to. I do link to several
    external worksheets, but those links are not active when I first open Excel.

    Thoughts?

    Thanks!

    PJ
     
    PJFry, May 27, 2009
    #1
    1. Advertisements

  2. Hi PJFry,
    I suspect there is a defined range name in the workbook called Auto_open which
    points to #ref!#Ref.
    Download my Name Manager and check the workbook in question for range names
    with errors and remove them.

    Regards,

    Jan Karel Pieterse
    Excel MVP
    http://www.jkp-ads.com
    Member of:
    Professional Office Developer Association
    www.proofficedev.com
     
    Jan Karel Pieterse, May 28, 2009
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.