#1   Report Post  
Posted to microsoft.public.excel.misc
Joe Man
 
Posts: n/a
Default Cannot open file

I have a file afew folders deep in my c: drive named "Used for May
BirthdaysJSmith" without the parenthesis. When I double-click to open it,
Excel says it can't find the file. This happens whether I try to open it from
within Excel or just double-click it to lunch Excel. If I move the same file
to the Desktop, it opens fine with no errors.

Also, If I leave the file where I was getting errors but just remove the
JSmith from the end of the file name, it opens fine from there too.

I have all Office and WinXP updates. Any ideas on what's going on??
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Cannot open file

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)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Joe Man wrote:

I have a file afew folders deep in my c: drive named "Used for May
BirthdaysJSmith" without the parenthesis. When I double-click to open it,
Excel says it can't find the file. This happens whether I try to open it from
within Excel or just double-click it to lunch Excel. If I move the same file
to the Desktop, it opens fine with no errors.

Also, If I leave the file where I was getting errors but just remove the
JSmith from the end of the file name, it opens fine from there too.

I have all Office and WinXP updates. Any ideas on what's going on??


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Joe Man
 
Posts: n/a
Default Cannot open file

I figured out what the problem was. The filepath was too long. It was several
folders deep and it exceeded the maximum length. I didn't even know there was
a maximum.

"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)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Joe Man wrote:

I have a file afew folders deep in my c: drive named "Used for May
BirthdaysJSmith" without the parenthesis. When I double-click to open it,
Excel says it can't find the file. This happens whether I try to open it from
within Excel or just double-click it to lunch Excel. If I move the same file
to the Desktop, it opens fine with no errors.

Also, If I leave the file where I was getting errors but just remove the
JSmith from the end of the file name, it opens fine from there too.

I have all Office and WinXP updates. Any ideas on what's going on??


--

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
file will not open txskyhawk Excel Discussion (Misc queries) 4 April 19th 06 12:35 AM
Open last file with certain file name GEORGIA Excel Discussion (Misc queries) 5 April 13th 06 01:48 PM
file is locked does not appear in Excel if file already open by an Leslie New Users to Excel 3 April 10th 06 09:40 PM
Advised file is open when not the case deniseh Excel Discussion (Misc queries) 1 November 3rd 05 01:37 PM
How do you open a template at startup? James Kendall Excel Discussion (Misc queries) 7 July 26th 05 07:33 PM


All times are GMT +1. The time now is 03:42 PM.

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

About Us

"It's about Microsoft Excel"