sillybell
asked on
xlsx files open with new name
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???
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???
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?
ASKER
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\b ook.xlsx" Excel is breaking the location up into three different files and adding it's extension.
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\
The location of the file is "C:\documents and settings\william\desktop\b
Did you have the Use DDE option checked in the properties for the Open action?
ASKER
Yes
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
ASKER
It's already unchecked.
Ok - what was in the command line section of the properties for the Open action?
ASKER
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
Actions: &Open
Application used to perform action: "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE"
Use DDE : Checked
DDE Message:
Application: EXCEL
DDE Application Not Running:
Topic: System
Remove the %1 from the command line
ASKER
Removed "%1". Still getting same error.
Can you double check it's gone? (has been known to reappear!)
ASKER
You're right. It's back. Everytime I remove it and go back in, it comes back.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks rorya!!!! That did it!!!