[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • 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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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