Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File names in Range names (Excel 2000)

    In a couple of other posts I asked about hangups in Excel opening. I have determined that the files Excel is attempting to open are referenced in Range Names. Nobody else around me has this problem (opening the same file) where I get "File Not Found" windows dialog boxes for each file that is in a Range Name. I would appreciate a link to that "Systematic Approach.." article by an MVP. I thought I had it. I tried opening it in Run "etc...../Automatic. based on a thread. Same problem occured. So what settings in Excel can I use to halt this? Other folks have the Update links checked yet do not experience these annoying and time-consuming window dialogs. Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: File names in Range names (Excel 2000)

    > I would appreciate a link to that "Systematic Approach.." article by an MVP.

    See <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>. You can easily find this and other star posts through the <!post=MS Office Star Posts,392025>MS Office Star Posts<!/post> link below the Lounge menu bar. There are similar links for other star post indexes.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File names in Range names (Excel 2000)

    I'd suggest the following:

    - download my Name Manager
    - Install it (you'll find it in the Tools menu)
    - Open Excel and press alt-F11 to open the Visual Basic Editor
    - Choose Insert, module from the menu.

    Type this code:

    Sub OpenMyBook()
    Application.Calculation=xlCalculationManual
    Workbooks.Open "c:My DocumentsTheNameOfTheFile.xls", UpdateLinks:=0
    End Sub

    Change the path and filename to match your problem file.
    Place your cursor in the subroutine above and hit F5 to run it.
    When it loads, start my Name Manager and choose to filter for names with external references.
    Fix them or delete them.
    Set calc back to automatic (tools, options, calculation)
    Save the workbook.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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