#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default File Opening Trouble

When I double click on an Excel file to open it, I get a series of messages
that files can not be found as follows:

Personal.xls is locked€¦
C:\My.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\and.xls cannot be found€¦.
C:\Settings.xls cannot be found€¦.etc.

It seems to be trying to open each word in the directory path as a separate
file. The separation seems to occur whenever it reaches a space or a slash
in the file path. This only happens with Excel files. All other files work
normally. Opening the file in Excel using the menu file/open€¦. works
normally.

Any ideas what could be causing this?

(Windows XP SP2, Office 2003)

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default File Opening Trouble

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.

JGreg7 wrote:

When I double click on an Excel file to open it, I get a series of messages
that files can not be found as follows:

Personal.xls is locked€¦
C:\My.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\and.xls cannot be found€¦.
C:\Settings.xls cannot be found€¦.etc.

It seems to be trying to open each word in the directory path as a separate
file. The separation seems to occur whenever it reaches a space or a slash
in the file path. This only happens with Excel files. All other files work
normally. Opening the file in Excel using the menu file/open€¦. works
normally.

Any ideas what could be causing this?

(Windows XP SP2, Office 2003)


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default File Opening Trouble

Easiest fix is...............

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.

If no joy with that, post back and we can propose another fix.


Gord Dibben MS Excel MVP

On Mon, 2 Mar 2009 11:19:01 -0800, JGreg7
wrote:

When I double click on an Excel file to open it, I get a series of messages
that files can not be found as follows:

Personal.xls is locked…
C:\My.xls cannot be found….
C:\Documents.xls cannot be found….
C:\Documents.xls cannot be found….
C:\and.xls cannot be found….
C:\Settings.xls cannot be found….etc.

It seems to be trying to open each word in the directory path as a separate
file. The separation seems to occur whenever it reaches a space or a slash
in the file path. This only happens with Excel files. All other files work
normally. Opening the file in Excel using the menu file/open…. works
normally.

Any ideas what could be causing this?

(Windows XP SP2, Office 2003)


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default File Opening Trouble

The "unregserver / regserver" procedure worked, thank you for your response.

Excel works normally now.

"Gord Dibben" wrote:

Easiest fix is...............

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.

If no joy with that, post back and we can propose another fix.


Gord Dibben MS Excel MVP

On Mon, 2 Mar 2009 11:19:01 -0800, JGreg7
wrote:

When I double click on an Excel file to open it, I get a series of messages
that files can not be found as follows:

Personal.xls is locked€¦
C:\My.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\and.xls cannot be found€¦.
C:\Settings.xls cannot be found€¦.etc.

It seems to be trying to open each word in the directory path as a separate
file. The separation seems to occur whenever it reaches a space or a slash
in the file path. This only happens with Excel files. All other files work
normally. Opening the file in Excel using the menu file/open€¦. works
normally.

Any ideas what could be causing this?

(Windows XP SP2, Office 2003)



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Can't open TSV file

I'm having this same problem. Running Excel 2003 sp2. When opening a .tsv
file I get this same series of errors. I've tried the unregister/reregister
suggestion but Excel still can't open .tsv files. Any other suggestions?

Jason


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default Can't open TSV file

What is a TSV file? Tab separated values? If so, change the file's
extension from tsv to txt and use Excel's import text file tool.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 23 Mar 2009 08:19:04 -0700, WJason
wrote:

I'm having this same problem. Running Excel 2003 sp2. When opening a .tsv
file I get this same series of errors. I've tried the unregister/reregister
suggestion but Excel still can't open .tsv files. Any other suggestions?

Jason

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default My solution

Open Folder Options from the Control Panel. Click the [File Types] tab and
scroll down to the TSV entry. Click the [Advanced] button. For each action
listed, highlight to select it and then click [Edit] to edit it. Scroll to
the end of the "Application used to perform action" field and place
double-quote (") marks around %1 at the end of the entry.

I still don't understand why some workstations can open TSV files without
this modification and some cannot (all running XP Pro,sp3 and MSO2003sp3);
but the solution worked for me.
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default TSV file

TSV = Tab Separated Values
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 226
Default File Opening Trouble

Sorry but none of these seem to work. I have posts under msg
"Open excel files" and "Can't open an excel file (have......"

At this point I suspect my problem can be traced to a botched removal of
Office 2007 and editing the registry per instructions from MS at
http://support.microsoft.com/kb/928218

After removing all traces of Office 2007 and 2003 I could find I did fresh
install of 2003 and have installed all updates and compatability pack
available but I either can not open an .XLS file with dbl click or have to
put up with three error messages.

TO ALL who respond. I will try your suggestions and only make another post
when something works.


"Dave Peterson" wrote:

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.

JGreg7 wrote:

When I double click on an Excel file to open it, I get a series of messages
that files can not be found as follows:

Personal.xls is locked€¦
C:\My.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\Documents.xls cannot be found€¦.
C:\and.xls cannot be found€¦.
C:\Settings.xls cannot be found€¦.etc.

It seems to be trying to open each word in the directory path as a separate
file. The separation seems to occur whenever it reaches a space or a slash
in the file path. This only happens with Excel files. All other files work
normally. Opening the file in Excel using the menu file/open€¦. works
normally.

Any ideas what could be causing this?

(Windows XP SP2, Office 2003)


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble opening an XLS. and XLM. file in Microsoft 2000 JB Excel Discussion (Misc queries) 2 August 6th 08 04:38 PM
trouble opening old 5.0 file Karen Excel Discussion (Misc queries) 0 April 20th 07 02:34 AM
Trouble opening file from desktop...Help Hootywho Excel Discussion (Misc queries) 2 August 4th 06 02:10 AM
Trouble opening excel file weimar Excel Discussion (Misc queries) 2 March 7th 06 05:07 PM
Trouble opening an Excel file that contains macros JohnR Excel Worksheet Functions 1 March 8th 05 08:09 PM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"