• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

Excel 2007 can't open files with spaces in names

This is a problem that suddenly started happening today.  I was mucking around with Excel trying to get it to open each new file in a new window (problem solved thanks to EE) and I must have clicked somethign I shouldn't have.

Excel is suddenly unable to open files with spaces in the name.  For example, if my file name is "My hours.xlsx" and I double click on it, Excel tells me "My.xlsx" could not be found, and then it tells me "hours.xlsx" could not be found.

As far as I can tell, it's only Excel that is having this problem so I don't think it was caused by changes to Windows, but I could be wrong...
0
FrancineTaylor
Asked:
FrancineTaylor
  • 2
1 Solution
 
rockiroadsCommented:
see if the solution here works for you http://www.eggheadcafe.com/software/aspnet/30992720/filename-spaces.aspx


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.
0
 
rockiroadsCommented:
if you are trying to open files within code then ensure you wrap the filename in double quotes
0
 
FrancineTaylorAuthor Commented:
Thanks, rockiroads, that worked!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now