To restrict the types of files that you can open or save in Excel 2010, an administrator can use the 2010 Office System Administrative Templates to configure the registry on the client computer.
- To download the 2010 Office System Administrative Templates, visit the following Microsoft Web site:
- For more specific information about how to use settings to block the opening and saving of file formats in the 2010 Office programs, visit the following Microsoft Web site, and then see the "Group Policy overview for Office 2010" topic:
:
To restrict the types of files that you can open in
Excel 2007, an administrator can use the 2007 Office System Administrative
Templates to configure the registry on the client computer.
The
following table contains the DWORD names that an administrator can add to the
registry to restrict certain file types by using the FileOpenBlock subkey.
Additionally, the table contains the corresponding file types that are
restricted.
| DWORD name | File types that are restricted |
|---|
| OpenXmlFiles | .xlsx, .xlsm, .xltx, .xltm, .xlam |
| Binary12Files | .xlsb |
| BinaryFiles | .xls, .xla, .xlt, .xlm, .xlw, .xlb |
| HtmlandXmlssFiles | .mht, .mhtml, .htm, .html, .xml,
.xmlss |
| XmlFiles | .xml |
| DifandSylkFiles | .dif, .slk |
| TextFiles | .txt, .csv, .prn |
| XllFiles | .xll (.dll) |
- To download the 2007 Office System Administrative
Templates, visit the following Microsoft Web site:
- For more specific information about how to use settings to
block the opening and saving of file formats in the 2007 Office programs, visit
the following Microsoft Web site, and then see the "Enforce settings by using
Group Policy in the 2007 Office system" topic:
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, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
An administrator can restrict the types of files
that you can open
in Excel 2003. This ability was not provided in Microsoft Office 2003
when it was originally released. To restrict the types of files that can be
opened in
Excel 2003, install security update 933666.
For more information about security
update 933666, click the following article number to view the article in the
Microsoft Knowledge Base:
933666
Description of the security update for Excel 2003: May 8, 2007
To restrict the types of files that you can
open in
Excel 2003, an administrator can use one of the following methods:
- Use the updated Office 2003 Administrative Templates to
configure the registry on the client computer.
- Modify the registry by adding a registy key setting on the
client computer. To download the Office 2003 Service Pack 3 Administrative
Template (ADM), OPAs, and Explain Text Update, visit the following Microsoft
Web site:
The following table contains the DWORD names that an
administrator can add to the registry to restrict certain file types by using
the FileOpenBlock subkey. Additionally, the table contains the corresponding
file types that are restricted.
| DWORD name | File types that are restricted |
|---|
| BinaryFiles | .xls, .xla, .xlt, .xlm, .xlw, .xlb |
| HtmlandXmlssFiles | .mht, .mhtml, .htm, .html, .xml,
.xmlss |
| XmlFiles | .xml |
| DifandSylkFiles | .dif, .slk |
| TextFiles | .txt, .csv, .prn |
| XllFiles | .xll |
| Converters | All file formats that are available by
using a text converter (including the Office Compatibility Pack) |
| DatabaseandDatasourceFiles | .odc, .udl, .dsn, .dbc,
.dqy, .iqy, .oqy, .rqy, .mde, .mdb, .dbf, .ade, .adp, .cub |
| LotusandQuattroFiles | .wk1, .wk4, .wj3, wk1 FMT, .wks,
.wk3, wk3 FM3, .wj2, .wq1, .fm3, .wj1 |
| LegacyBinaryFiles | Microsoft Excel 4.0 Charts (.xlc) files
(Office 2003 SP3) |
| LegacyDatabaseAndDatasourceFiles | DBF 2 (dBASE II)
(.dbf) files (Office 2003 SP3) |
To enable the FileOpenBlock subkey settings, follow these steps:
- Exit Excel.
- If you are running
Excel 2003, install
security update 933666 if it is not installed, and then go to step 3. If you are running Excel 2007, go to step 3.
- Click Start, click Run,
type regedit in the Open box, and then
click OK.
- Locate and then click to select one of the following
registry subkeys:
Excel 2007HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\FileOpenBlock
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Excel\Security\FileOpenBlock
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileOpenBlock
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Security\FileOpenBlock
- Click to select the Security
subkey.
- On the Edit menu, point to
New, and then click Key.
- Type FileOpenBlock, and then
press ENTER.
- Point to New on the Edit
menu, and then click DWORD Value.
- Type the DWORD name that you want to restrict, and then
press ENTER. For example, type BinaryFiles.
- Right-click the DWORD name that you typed in step 6, and
then click Modify.
- In the Value data box, type
1, and then click OK.
- On the File menu, click
Exit to exit Registry Editor.
For
more information, click the following article number to view the article in the
Microsoft Knowledge Base:
945797
You receive an error message when you try to save a file type that was blocked by your registry policy settings in Excel 2007 or in Excel 2003
Article ID: 922848 - Last Review: May 31, 2012 - Revision: 13.0
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Excel 2010
| kbsavefile kbopenfile kberrmsg kbexpertisebeginner kbtshoot kbprb kbcip KB922848 |