Many frustrations, hate and anti-Microsoft feelings when an Office document opens in Internet Explorer...again. You know it does, but you remember when you already clicked the document. Especially in Sharepoint, this happens all the time. Sounds familiar?
The solution for this is quite simple:
To configure Internet Explorer to open Office files in the appropriate Office program by using the Folder Options tool:
| 1. |
Open My Computer. |
| 2. |
On the Tools menu (or the View menu), click Folder Options (or click Options). |
| 3. |
Click the File Types tab. |
| 4. |
In the Registered file types list, click the specific Office document type (for example, Microsoft Excel Worksheet), and then click Advanced (or click Edit). |
| 5. |
In the Edit File Type dialog box, click to clear the Browse in same window check box (or click to clear the Open Web documents in place check box). |
| 6. |
Click OK. |
Or,
Method 2: Edit the Windows Registry
To configure Internet Explorer to open Office files in the appropriate Office program by editing the Windows registry, set the BrowserFlags DWORD value to 8 (or 9 for Microsoft Excel worksheets) for the appropriate document type. To do this, follow these steps:
| 1. |
Start Registry Editor (Regedt32.exe). |
| 2. |
Locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Classes |
| 3. |
Locate the subkey for the specific Office document type. The following table lists the subkeys for several common Office document types. Document Type Subkey
----------------------------------------------------------------
Microsoft Excel 7.0 worksheet Excel.Sheet.5
Microsoft Excel 97 worksheet Excel.Sheet.8
Microsoft Excel 2000 worksheet Excel.Sheet.8
Microsoft Word 7.0 document Word.Document.6
Microsoft Word 97 document Word.Document.8
Microsoft Word 2000 document Word.Document.8
Microsoft Project 98 project MSProject.Project.8
Microsoft PowerPoint 2000 document PowerPoint.Show.8
To locate the subkey for a document type that is not included in this table, find the subkey for the extension that is associated with the document type. The (default) value for that subkey contains the name of the subkey for that document type. For example, the .xls extension is associated with Excel worksheets. Under the .xls subkey, the (default) value contains the string "Excel.Sheet.5." Therefore, the subkey for the Microsoft Excel Worksheet document type is the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.5 |
| 4. |
After you identify the subkey for the specific Office document type, add the following value for all subkeys except Excel.Sheet.5:
Value name: BrowserFlags
Data type: REG_DWORD
Value: 8 For Excel.Sheet.5, add the following value:
Value name: BrowserFlags
Data type: REG_DWORD
Value: 9 |
| 5. |
Click OK, and then quit Registry Editor. |
There you go.. :)
More info: http://support.microsoft.com/kb/162059/en-us