How to open a .tsv file in Excel 2010 on Windows 7 workstation by default.

Posted on 2013-10-22
Last Modified: 2013-11-11
I am using Excel 2010 on a Windows 7 Pro 64-bit workstation.
I associated the .tsv file with Excel located specifically here:
C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
It opened fine.

However on one of my user's machines (same exact setup as mine) she cannot do this.
She attempts to associate .tsv with Excel but when it opens it opens a window which says "Microsoft Office 2010" as the name of the app???? I didn't know a Microsoft Office 2010 app existed? What is opens is a little square in the middle which shows a broken link and no information. Very weird.

We tried associating the .tsv extension with EXCEL.EXE multiple times and when we look at the association under the "Current Default" column it lists the association as "Microsoft Office 2010" instead of "Microsoft Excel" (which it shows correctly on my machine).

Can anyone tell me what is going on here and how I can fix this on her machine?
Question by:rr4406pak
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
  • 4
LVL 10

Assisted Solution

ecarbone earned 500 total points
ID: 39592974
What you are seeing is an application called 'Microsoft Picture Manager'

It's part of the Office suite 'Proofing Tools'
I don't think I've ever used it, but it gets installed as part of Office.

Here's how to change the association:

1. Go to Control Panel > Programs > Default Programs > Set Associations
2. Find ".tsv" in the list of files. Click once to highlight it.
3. Click the "Change Program..." button.
4. In the pop-up windows, click "More options"
5. In this larger list that appears, select "Microsoft Excel". If Excel does not appear in that list, scroll all the way to the bottom and select "Look for another app..."
6. Most likely you have the 32-bit version of Office installed, but by default, you will be directed to the 64-bit applications folder. So navigate up one level (to the root of your drive), then double-click on "Program Files (x86)".
7. Double click on the Microsoft Office folder
8. Double click on the "Office" folder with the highest number. (For example, Office15 or Office14 or Office12)
9. Inside that folder, select "EXCEL.EXE" and click Open

When that process is complete, close the Control Panel and your .tsv file should now have an Excel icon.

If the steps above do not work, go to, download and install CCleaner. Run this free utility on your computer and let it clear out all of your temporary files. Then try the steps above once more.

Assisted Solution

rr4406pak earned 0 total points
ID: 39594247
In your step #1 I have no "Set Associations" option. All I have is a "Associate a file type or protocol with a program".
I clicked on that anyway.
When I get to your step #4 I do not have a "More Options" selections at all. Only choice I have is "Browse...".
I can get no 'larger list' to come up.

Accepted Solution

rr4406pak earned 0 total points
ID: 39627429
Only way I solved this problem was to delete the user's profile completely from the computer. Made sure she backed up her internet browser bookmarks and saved any signatures in Outlook before I did it (user's get cranky when you delete this stuff on them).
Once her profile was recreated the association worked perfectly.
Have no idea why it would not work right with her old profile.
Something had to be corrupted in there.

Author Comment

ID: 39627432
Thank you.

Author Closing Comment

ID: 39638269
Recreating profile was the answer.

Featured Post

Get MySQL database support online, now!

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

Question has a verified solution.

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

Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

617 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