File Name Length Error

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

Hi. This is a really strange problem and i cant firgure
out why it could possibly be happening but hopefully
somebody here can help me out.

On one of my servers i have the following problem: When 3
of my workstations(all ghosted with the same image) try to
open an Excel file every part of the directory opens in
its own seperate window. For example,
Server/drive/folder/excel file will all open in seperate
windows.
This only happens with files whos names are approximately
more than 12 characters. If the file name is less than
that the file opens without any problems.

I've already uninstalled/reinstalled office. Furthermore
when i open an excel file off of that server from a
different location(not one of its local ghosted pc's) the
file opens fine regardless of name length.

Any help you could give me would be really appreciated.
Thanks so much

Joseph
 
Hi Joseph,
On one of my servers i have the following problem: When 3
of my workstations(all ghosted with the same image) try to
open an Excel file every part of the directory opens in
its own seperate window. For example,
Server/drive/folder/excel file will all open in seperate
windows.
This only happens with files whos names are approximately
more than 12 characters. If the file name is less than
that the file opens without any problems.


Try this:

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 Files\Microsoft Office\Office\EXCEL.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
b) 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)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top