Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not open .xls files via Windows Explorer
If I attempt to open a .xls with Excel 2003 via Windows Explorer,
Excel opens, but the sheet is never displayed, I receive a windows error message stating the correct file lactation, but that the specific file can not be found. If I then repeat the same process, double click the .xls in Windows Explorer, Excel will open the file. If I have already opened Excel I can use the fileopen menu to select any .xls and it will open. I suspect the problem may be with windows explorer, but users of Excel may have experienced this problem. Vista SP1 and Microsoft Office 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not open .xls files via Windows Explorer
The limit to the filename (including path) that can be opened is around 128
characters. When the filename is between 120 and 128 you get different error messages depending if you are opening the the file from window explorer or from inside excel. You can either more the file to a different locattion or what I do is add a new mapped drive in the window explorer with a shorter path. Add a new mapped drive ( like X:) and instead of mapping it to the root folder on the network drive map X: to the folder where your file is located,or any folder that would give you less than 120 characters in you path. You can add the mapped dirve in the window explorer by going to menu First find the present mapping for the dirve you arre using by going to menu Tools - disconnect NetWork Drive Then write down the Network path for the drive being used like for S: Then go to menu Tools - Map Network Drive Explorer will automaticlly choose a drive that is not mapped Enter in to folder box the path you wrote down. then press Browse and find the folder where you file is located. "paulmitchell507" wrote: If I attempt to open a .xls with Excel 2003 via Windows Explorer, Excel opens, but the sheet is never displayed, I receive a windows error message stating the correct file lactation, but that the specific file can not be found. If I then repeat the same process, double click the .xls in Windows Explorer, Excel will open the file. If I have already opened Excel I can use the fileopen menu to select any .xls and it will open. I suspect the problem may be with windows explorer, but users of Excel may have experienced this problem. Vista SP1 and Microsoft Office 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not open .xls files via Windows Explorer
Also make sure that there are no special characters in the path or filename
which will conflict with html code. Characters like !@#&% are acceptable in filenames but cannot be used in links. "Joel" wrote: The limit to the filename (including path) that can be opened is around 128 characters. When the filename is between 120 and 128 you get different error messages depending if you are opening the the file from window explorer or from inside excel. You can either more the file to a different locattion or what I do is add a new mapped drive in the window explorer with a shorter path. Add a new mapped drive ( like X:) and instead of mapping it to the root folder on the network drive map X: to the folder where your file is located,or any folder that would give you less than 120 characters in you path. You can add the mapped dirve in the window explorer by going to menu First find the present mapping for the dirve you arre using by going to menu Tools - disconnect NetWork Drive Then write down the Network path for the drive being used like for S: Then go to menu Tools - Map Network Drive Explorer will automaticlly choose a drive that is not mapped Enter in to folder box the path you wrote down. then press Browse and find the folder where you file is located. "paulmitchell507" wrote: If I attempt to open a .xls with Excel 2003 via Windows Explorer, Excel opens, but the sheet is never displayed, I receive a windows error message stating the correct file lactation, but that the specific file can not be found. If I then repeat the same process, double click the .xls in Windows Explorer, Excel will open the file. If I have already opened Excel I can use the fileopen menu to select any .xls and it will open. I suspect the problem may be with windows explorer, but users of Excel may have experienced this problem. Vista SP1 and Microsoft Office 2003. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not open .xls files via Windows Explorer
Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer: Tools|Options|General|Ignore other applications (uncheck it) (xl2003 menus) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. paulmitchell507 wrote: If I attempt to open a .xls with Excel 2003 via Windows Explorer, Excel opens, but the sheet is never displayed, I receive a windows error message stating the correct file lactation, but that the specific file can not be found. If I then repeat the same process, double click the .xls in Windows Explorer, Excel will open the file. If I have already opened Excel I can use the fileopen menu to select any .xls and it will open. I suspect the problem may be with windows explorer, but users of Excel may have experienced this problem. Vista SP1 and Microsoft Office 2003. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Open Vs Opening from Windows Explorer | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Excel files won't open from Windows Explorer | Excel Discussion (Misc queries) | |||
How do I print multiple files from windows explorer? | Excel Discussion (Misc queries) | |||
windows explorer will not open an excel spreadsheet. | Excel Discussion (Misc queries) |