Go Premium for a chance to win a PS4. Enter to Win

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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