Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Shortcut Problems (Excel 2000 SR-1)

    I keep a number of shortcuts in my Start Menu. Yesterday I launched one that, for some reason, had lost its Excel icon and was just showing the default file icon. Windows said that it could not find Excel.exe, so I "browsed" the location. Excel opened, the file opened, and then it gave me an error message "You cannot open two documents with the same name..." All my Excel links are misbehaving like this now. It's as if Excel is trying to open two copies of the file every time a shortcut is used. This is affecting only Excel, and none of my other installed Office products. I think it may have something to do with the file associations (and thus a Windows 98 problem and not Excel), but everything looks normal.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut Problems (Excel 2000 SR-1)

    Assuming you know how to safely do it, I suggest renaming the Excel folder key in the registry:

    hkey_current_usersoftwaremicrosoftoffice9.0excel

    Rename to something like OldExcel and relaunch Excel.

    Or Start-Run:

    excel.exe /regserver

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Shortcut Problems (Excel 2000 SR-1)

    I managed to "fix" the problem without diving into the registry this time. I went into the File Types listing and removed the .XLS extension from the list and then opened a worksheet from Explorer. Explorer let me re-associate the file to Excel and the double-loading errors went away (although I lost the "Print" and other right-click options). Then today I tracked down the installation CD and did a "Find & Repair" to get everything back to normal again. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Still, I have no idea what went wrong in the first place, but given that it's Microsoft Office running on Microsoft Windows chances are that it'll happen again. <img src=/S/sarcasm.gif border=0 alt=sarcasm width=15 height=15>

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

    Re: Shortcut Problems (Excel 2000 SR-1)

    Next time this happens to you.let Excel itself repair things:

    Start, Run
    Enter this:

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver
    and press OK.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Shortcut Problems (Excel 2000 SR-1)

    I ran the /regserver command, and it appears to do the same as Excel's (Office in general's?) "Detect and Repair" Help menu option. Is there any difference in using the /regserver command switch versus the "Detect and Repair" option from the Help menu or even from the install CD's Setup?

    Sidenote -- the "Detect and Repair" command would not function from within Excel, but it could be run from other Office applications though I did the repair using the install CD.

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

    Re: Shortcut Problems (Excel 2000 SR-1)

    I must admit I don't know <g>. This advice works for both XL 97 (which has no detect and repair) and xl2K, so I often don't bother to spot the version and just advise this.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: Shortcut Problems (Excel 2000 SR-1)

    One of the main differences is that the regserver fix does not require the install CD. However, all it does is set XL's registry settings back to their default values. The Detect and Repair will fix other things, like missing DLL files, but requires the install CD to work.
    Legare Coleman

  8. #8
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Shortcut Problems (Excel 2000 SR-1)

    Now that is an important distinction! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Where do you find out about all of these different command line switches? Is there a master listing of them available somewhere? I've looked in the help files, and from their lack of documentation I'd almost think Microsoft didn't want us knowing about them! <img src=/S/sarcasm.gif border=0 alt=sarcasm width=15 height=15>

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

    Re: Shortcut Problems (Excel 2000 SR-1)

    I find out about most of them here. The person who first posted it here probably found out by having someone at MS Support suggest it as a possible fix to some problem.
    Legare Coleman

  10. #10
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Shortcut Problems (Excel 2000 SR-1)

    Ah, the old "Hoard Knowledge" trick -- don't tell people what you know until they have to come begging for it, thus receiving a heady rush of exhilaration from the power trip. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  11. #11
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Shortcut Problems (Excel 2000 SR-1)

    Hi David,

    The MS Knowledge Base has the following articles which show XL startup switches :

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q211/4/81.ASP?>XL 2000

    Andrew

  12. #12
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Shortcut Problems (Excel 2000 SR-1)

    MS used to give this info when they offered "technical" courses on the application side. The MOUS courses I've seen really don't go into depth.
    Sigh!
    The lack of in-depth courses available for applications is real sticking point for me. Of course, it isn't just Microsoft. WordPerfect also provides (I've gotta admit I don't know if they do currently) "technical" style training on its' products. They've kept it pretty quiet tho'.
    Of course, the reason behind this is money. MS (and perhaps others) never made enough money selling their technical apps courses to make it worth while. So they've thrown all their efforts into BackOffice Technical courses.

    Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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