Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Did Microsoft lie? - Excel Viewer (97-2000)

    For obvious reasons, we're trying to limit the number of PCs in our organization that utilize MS Office. One of the ways we're doing this is to use the Microsoft Office viewers. Microsoft claims that the Excel 97/2000 viewer works on the Windows 95 OS. We're finding, however, that if we try to open files with multiple-word names, we'll get an error for every individual word as the viewer tries to open it.

    For example: if I open a file called Sql Backups.xls, the viewer
    - tries to open Sql.xls and errors ("'F:EXCELsql.xls' could not be found. Check the spelling...."),
    - then attempts to open Backups.xls and errors ("'F:EXCELsql.xls' could not be found. Check the spelling....")
    - then prompts me to open the correct file. If I click on Cancel at this point, the Sql Backups.xls file appears as it should.

    Is this a problem with the viewer, or is it something else I missed?

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

    Re: Did Microsoft lie? - Excel Viewer (97-2000)

    Can you explain how you are opening these files? Are you opening the viewer and then using File/Open, or do you have a file association for the .xls extension to the viewer?
    Legare Coleman

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

    Re: Did Microsoft lie? - Excel Viewer (97-2000)

    This fix is for when one has Excel itself. Maybe option 2 gives you some clues how to fix it for the viewer:


    How to reinstate Excel's ability to open files with spaces
    in their name/path by double clicking:

    1. Have Excel correct it

    1. Choose start (Start button), Run, type:
    "C:Program FilesMicrosoft OfficeOfficeEXCEL.EXE" /Regserver
    2. Click OK

    2. Do it yourself

    1. Open Windows Explorer.
    2. Choose from its menu: View, Options. (or View / Folder Options in Windows 98)
    3. Select the File Types tab
    4. Scroll to Microsoft Excel Worksheet
    5. Click Edit
    6. Select the OPEN entry (it should be highlighted (bolded)
    7. Click Edit and check that the fields are set as follows:
    a) Application used: should be EXCEL.EXE, loaded from the correct directory
    [img]/forums/images/smilies/cool.gif[/img] Use DDE should be checked
    c) The DDE message should be (exactly): [Open("%1")]
    d) Application should be: excel
    e) DDE Application not running should be empty
    f) Topic should be: system
    8. Click OK
    9. Click Close
    10. If you wish to double-click other Excel file types, e.g. template
    (xlt) or workspace (xlw), select the appropriate type in the File Types
    tab and repeat from step (5)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Did Microsoft lie? - Excel Viewer (97-2000)

    We get the error when we double-click to open--either an e-mail attachment or from My Computer / Windows Explorer.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Did Microsoft lie? - Excel Viewer (97-2000)

    Ok, just to clarify: This is what you do when the full version of Excel gives you that error, and you're thinking it will be a similar solution for the viewer?

    Thanks!

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

    Re: Did Microsoft lie? - Excel Viewer (97-2000)

    Not thinking, hoping <smile>.

    Seriously, it is the same type of error, so I thought maybe the remedy is similar.
    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: Did Microsoft lie? - Excel Viewer (97-2000)

    If that is the case, then the second solution that Jan Karel gave you should fix the problem with one change, in step 7a the application used should be the viewer, not Excel. The thing that needs to be done is to get the %1 inside double quote marks.
    Legare Coleman

  8. #8
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Did Microsoft lie? - Excel Viewer (97-2000)

    Thanks to both of you we were able to figure it out. We tried following the steps and they did not work, but since the problem was exclusive to Excel, we looked at the way the Word and PowerPoint viewers were launching by file extension. In the PowerPoint one, the "use DDE" option had been turned OFF, but the command line was modified. By mimicking this approach, and by playing around a bit, we came up with this command for Excel and it worked!
    - turned OFF "Use DDE"
    - used "crogram filesxlviewxlview.exe" "%1" as a command line

    Thank you both for your help!!

Posting Permissions

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