Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Files won't open once associated with Excel

14 Jan 2011   #1
GlennSimpson

Windows 7 32-bit Professional
 
 
Files won't open once associated with Excel

I have a friend who has Windows 7 and Office 2007. He needs to open tab-delimited files that are saved in the .dat format. He's wants to open them in Excel 2007.

We set up Excel as the default program (we had to manually browse to excel.exe. I also tried excelconv.exe). However, double-clicking on the file doesn't open it. It sorta blinks and then nothing happens.

We can open the files if we start in Excel and browse to the desired file that way.

Is there perhaps a problem with the conversion dialog not opening when you double-click something? I think this used to work on his XP machine with Office 2003.


My System SpecsSystem Spec
.

14 Jan 2011   #2
Hopalong X

Windows7 Pro 64bit SP-1; Windows XP Pro 32bit
 
 

From what I read here .dat isn't an Excel supported file.

Microsoft Office Binary (doc, xls, ppt) File Formats
My System SpecsSystem Spec
14 Jan 2011   #3
GlennSimpson

Windows 7 32-bit Professional
 
 

I would think if that was the problem, the files wouldn't open when you opened them while already in Excel, but that's working (with the standard delimited file translation dialog).

These are just delimited text files, there's nothing hinky about the files.
My System SpecsSystem Spec
.


14 Jan 2011   #4
kado897

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

In 2010 it doesn't seem to be a data import format either. I'm sure it was at one time. If they are fixed format text files you may be able to import them by renaming to .txt

Update: You don't even need to rename them. Just select all file types in the text import wizard and you can chose between fixed format and delimited.
My System SpecsSystem Spec
14 Jan 2011   #5
Irene

Windows 7 Home Premium 64bit
 
 

There are two ways to import data from a text file by using Microsoft Office Excel:
You can open the text file in Excel, or you can import the text file as an external data range.

Detailed instructions contained in the following Article - Import or export text files - Excel - Microsoft Office

.
My System SpecsSystem Spec
14 Jan 2011   #6
GlennSimpson

Windows 7 32-bit Professional
 
 

Quote   Quote: Originally Posted by Irene View Post
There are two ways to import data from a text file by using Microsoft Office Excel:
You can open the text file in Excel, or you can import the text file as an external data range.

Detailed instructions contained in the following Article - Import or export text files - Excel - Microsoft Office

.
I took a look at that. Both methods refer to having Excel already open and getting to the data in some way. But I'm sure we can all agree that one should be able to just double-click on a file and have it open in the appropriate program. It used to do so.

This seems like an odd combination of a Windows 7 problem and and Excel 2007 problem, because I would imagine Windows 7 controls the functionality of "you just double-clicked on the file; I know I'm supposed to open that file type in X application, so I'm going to open that application and then try to open the file inside it", whereas Excel then takes over the process of opening the file from there. I'm not sure at what point in that process the problem is occurring.
My System SpecsSystem Spec
14 Jan 2011   #7
kado897

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

That's interesting. I just tried associating a .dat file with Excel 2010 and it opened it straight into Excel. This was just a random text file I renamed and it seems to have made a reasonable job of splitting it into columns. It wouldn't open with the converter and interestingly the converter in the open with dialog calls itself Excel. I wonder if you are picking that up as the default.
My System SpecsSystem Spec
14 Jan 2011   #8
GlennSimpson

Windows 7 32-bit Professional
 
 

I'll check and make sure we're trying to use excel, not the excelcnv. I know I tried that first and it didn't work, which is why I then tried the excelcnv.

This machine had some sequence of events like 2007 installed, then uninstalled and 2003 installed with the 2007 converter, and then that upgraded back to 2007, something like that. I fear that's what's causing the problem, but I don't know how to fix it barring a full reformat.
My System SpecsSystem Spec
14 Jan 2011   #9
GlennSimpson

Windows 7 32-bit Professional
 
 

Perhaps a valid question might be - what's the best way to completely and utterly delete all traces of Excel from a machine, returning all files and settings to their non-Excel state, so that I can then re-install and be sure that nothing will conflict?

That way hopefully whatever is causing the problem will be gone.
My System SpecsSystem Spec
14 Jan 2011   #10
kado897

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

I have never used it myself but people on this forum recommend Revo Uninstaller Download Revo Uninstaller Freeware - Free and Full Download - Uninstall software, remove programs, solve uninstall problems


I have found a tutorial on the forum. Revo Uninstaller Freeware - Uninstall Programs
My System SpecsSystem Spec
Reply

 Files won't open once associated with Excel




Thread Tools





Similar help and support threads
Thread Forum
Excel 2013 Won't Automatically Open Files
I am running into a bizarre problem with Excel 2013 and I can't seem to figure out the cause - searching around I couldn't find a solution, either. I have both Office 2010 64-bit and Office 365 (2013) 64-bit installed on my Windows 7 system. The only reason I still need 2010 is that 2013's...
Software
open XLA files in excel
hello i have a .XLA software that is an addin to excel. i would like to add functions to this xla file but dont know how to edit it... is there a way to do this or to know i can do it because the file is protected or something?
Microsoft Office
My excel files can't open
My excel files can't open it shows a message 'hot key 1 not working' what it means..? :(
Microsoft Office
Open files in new instance of Excel
Hi guys, I'm just wondering if there is a way that when I open a file in Excel, then open another it doesn't open in the same instance. Because I normally I want to snap them left or right. I can right click > open a new instance and drag the file into it which creates to instances and a new...
Microsoft Office
can't open (excel) files
Hi All ... When I am in Explorer and My Documents and I try to double click open an Excel file (Office 2003), I get the error message: "There was a problem sending the command to the program." However, if I try to similarly open a Word, or .PDF, or .TXT file in a similar manner, there is no...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 20:03.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App