Solved

xlsx files open with new name

Posted on 2011-03-09
14
470 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
 

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
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.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now