Solved

xlsx files open with new name

Posted on 2011-03-09
14
482 Views
Last Modified: 2012-06-27
I have an odd problem occurring on my laptop. I'm running WinXP SP3 and Office 2007.

When I open an xlsx file, it's opened as a new file. For instance, I have a file on my desktop called 'book.xlsx'. When I double click this file to open it, it's opened as 'book1.xls'. If I make any changes, it acts like it's a completely new file when I try to save it. Saving as 'book.xlsx' asks to overwrite. It doesn't happen with xls files or any other office 2007 extension.

Any ideas???
0
Comment
Question by:sillybell
  • 7
  • 7
14 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35084217
If you open windows Explorer, choose Tools- Folder Options, then on the File Types tab select .xlsx files, and press the Advanced button, is the New action shown in Bold, or is the Open action bold?
0
 

Author Comment

by:sillybell
ID: 35086159
The New action is bold and I see where you're going so I made the open action default.

Now when I try to open, I get three error messages...

1. 'C:\Documents.xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.

2. 'and.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

3. 'settings\william\Desktop\book.xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.

The location of the file is "C:\documents and settings\william\desktop\book.xlsx" Excel is breaking the location up into three different files and adding it's extension.

0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35087070
Did you have the Use DDE option checked in the properties for the Open action?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:sillybell
ID: 35087495
Yes
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35087628
Then in Excel options, in the advanced section, is the option to "ignore other applications that use dynamic data exchange (DDE)" checked? If so, uncheck it
0
 

Author Comment

by:sillybell
ID: 35087671
It's already unchecked.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35087998
Ok - what was in the command line section of the properties for the Open action?
0
 

Author Comment

by:sillybell
ID: 35088107
There is no command line in the properties. I have...

Actions: &Open
Application used to perform action: "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e %1
Use DDE : Checked
DDE Message:
Application: EXCEL
DDE Application Not Running:
Topic: System
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35088154
Remove the %1 from the command line
0
 

Author Comment

by:sillybell
ID: 35088209
Removed "%1". Still getting same error.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35088248
Can you double check it's gone? (has been known to reappear!)
0
 

Author Comment

by:sillybell
ID: 35088363
You're right. It's back. Everytime I remove it and go back in, it comes back.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 35088589
Try changing the %1 to "%1"
if that doesn't work, we may need to do a manual registry edit, but it would also be worth trying office diagnostics ( in the resources section of Excel Options)
0
 

Author Comment

by:sillybell
ID: 35089815
Thanks rorya!!!! That did it!!!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question