Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

xlsx files open with new name

Posted on 2011-03-09
14
Medium Priority
?
537 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

636 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