?
Solved

xlsx files open with new name

Posted on 2011-03-09
14
Medium Priority
?
523 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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 1000 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

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
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…

801 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