How To Open Excel

1. How To Open Excel
2. How To Open Excel
3. Open Excel File Online
4. How To Open Excel In 2 Windows

You can open the code window for an object by double-clicking on it in the Project Explorer area. Code window is where you'll write your code or copy paste a code from somewhere else. When you record a macro, the code for it goes into the code window of a module. Excel automatically inserts a module to place the code in it when recording a macro. Microsoft Excel is the industry leading spreadsheet program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel. Excel for Microsoft 365 for Mac, Excel 2019 for Mac, Excel 2016 for Mac Excel for Mac 2011 You can help prevent unauthorized users from opening or modifying a workbook file, even if they have permission to open it.

This article provides methods to set Internet Explorer to open Office documents in the appropriate Office program.

Original product version: Internet Explorer 10, Internet Explorer 9
Original KB number: 162059

Symptoms

When you select an HTML link to a Microsoft Office file (such as a Microsoft Word or Excel document), Internet Explorer may open the file in Internet Explorer, instead of opening the file in the appropriate Office program.

Cause

This behavior may occur if Internet Explorer is configured to host documents for Office programs that are installed on the computer. By default, Internet Explorer is configured to host documents for Office programs.

Resolution

To configure Internet Explorer to open Office files in the appropriate Office program instead of in Internet Explorer, use one of the following methods.

Note

These methods configure Internet Explorer to open Office files in the appropriate Office program for all users.

Method 1 - Use the Folder Options tool

How To Open Excel

Note

If you are running Windows NT 4.0, you may not be able to use the following procedure to configure Internet Explorer to open Office files in the appropriate Office program. If you are running Windows NT 4.0, use method 2.

Note

If you are running Terminal Server on Windows 2000 or Windows Server 2003, you may not be able to select Advanced to open the Edit File Type dialog box in step 4 of this procedure. This issue occurs if the NoFileAssociate policy is enabled. Enabling this policy prevents users (including administrators) from changing file type associations for all users.

To configure Internet Explorer to open Office files in the appropriate Office program by using the Folder Options tool:

These methods configure Internet Explorer to open Office files in the appropriate Office program for all users.

Method 1 - Use the Folder Options tool

How To Open Excel

Note

If you are running Windows NT 4.0, you may not be able to use the following procedure to configure Internet Explorer to open Office files in the appropriate Office program. If you are running Windows NT 4.0, use method 2.

Note

If you are running Terminal Server on Windows 2000 or Windows Server 2003, you may not be able to select Advanced to open the Edit File Type dialog box in step 4 of this procedure. This issue occurs if the NoFileAssociate policy is enabled. Enabling this policy prevents users (including administrators) from changing file type associations for all users.

To configure Internet Explorer to open Office files in the appropriate Office program by using the Folder Options tool:

How To Open Excel

1. Open My Computer.
2. On the Tools menu (or the View menu), select Folder Options (or select Options).
3. Select the File Types tab.
4. In the Registered file types list, select the specific Office document type (for example, Microsoft Excel Worksheet), and then select Advanced (or select Edit).
5. In the Edit File Type dialog box, clear the Browse in same window check box (or clear the Open Web documents in place check box).
6. Select OK.

Method 2 - Edit the Windows Registry

Important

This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, see How to back up and restore the registry in Windows.

To configure Internet Explorer to open Office files in the appropriate Office program by editing the Windows registry, set the BrowserFlags DWORD value to a correct value for the appropriate document type. To do this, follow these steps:

1. Start Registry Editor (Regedt32.exe).

2. Locate and then select the following registry key:

   HKEY_LOCAL_MACHINESOFTWAREClasses

3. Locate the subkey for the specific Office document type. The following table lists the subkeys for several common Office document types. How to play call of duty 1 multiplayer.

   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_MACHINESOFTWAREClassesExcel.Sheet.5

4. After you identify the subkey for the specific Office document type, follow these steps:

   1. If the Office document is a Microsoft Office Excel document, add the following value for all Microsoft Office Excel subkeys except the Excel.Sheet.5 subkey:

      Value name: BrowserFlags
      Data type: REG_DWORD
      Value: 8

      For the Excel.Sheet.5 subkey, add the following value:

      Value name: BrowserFlags
      Data type: REG_DWORD
      Value: 9

   2. If the Office document is a Microsoft Office Word document or a Rich Text Format document, add the following value for all Microsoft Office Word subkeys except the Word.Document.12 subkey, the Word.DocumentMacroEnabled.12 subkey, and the Word.RTF.8 subkey.

      Value name: BrowserFlags
      Data type: REG_DWORD
      Value: 8

      For the Word.Document.12 subkey, the Word.DocumentMacroEnabled.12 subkey and the Word.RTF.8 subkey, add the following value:

      Value name: BrowserFlags
      Data type: REG_DWORD
      Value: 44(Decimal)

   3. If the Office document is a Microsoft Office PowerPoint document, add the following value for all subkeys except PowerPoint.SlideShow.12 and PowerPoint.SlideShowMacroEnabled.12.

      Value name: BrowserFlags
      Data type: REG_DWORD
      Value: 10(Decimal)

      For PowerPoint.SlideShow.12 and PowerPoint.SlideShowMacroEnabled.12, delete the BrowerFlags if it exists.

5. Select OK, and then quit Registry Editor.

Applies to

• Internet Explorer 10
• Internet Explorer 9
• Office Home and Student 2013
• Office Professional Plus 2013
• Office Standard 2013
• Office Home and Business 2013
• Excel 2013
• PowerPoint 2013
• Word 2013
• Office Starter 2010
• Office Professional Plus 2010
• Office Standard 2010
• PowerPoint 2010
• Office Home and Business 2010
• Office Home and Student 2010
• Office Professional 2010
• Microsoft Word 2010
• Excel 2010
• Microsoft Office Excel 2007
• Microsoft Office PowerPoint 2007
• Microsoft Windows Server 2003 Web Edition
• Microsoft Windows Server 2003 Datacenter Edition (32-bit x86)
• Microsoft Windows Server 2003 Enterprise Edition (32-bit x86)
• Microsoft Windows Server 2003 Standard Edition (32-bit x86)
• Microsoft Office Excel 2003
• Microsoft Office Word 2003
• Microsoft Office PowerPoint 2003
• Microsoft Office Basic Edition 2003
• Microsoft Office Professional Edition 2003
• Microsoft Office Professional Enterprise Edition 2003
• Microsoft Office Standard Edition 2003
• Microsoft Windows XP Home Edition
• Microsoft Windows XP Professional
• Microsoft Windows XP Tablet PC Edition

Encrypt an Excel file with a password so that it requires a password to open it. To password protect an Excel file, execute the following steps.

1. Open an Excel file.

2. On the File tab, click Save As.

3. Click Browse.

4. Click on the Tools button and click General Options.

5. In the Password to open box, enter a password and click OK.

6. Reenter the password and click OK.

Note: this feature also encrypts your Excel file. If you lose or forget the password, it cannot be recovered.

Open Excel File Online

7. Enter a file name and click Save.

How To Open Excel In 2 Windows

It requires a password to open this Excel file now. The password for the downloadable Excel file is 'easy'.