You are attempting to open a file type that is blocked by your registry policy setting.
May 15, 2008 — avreneSYMPTOMS
CAUSE
For Excel 2007, the registry key can be set in the 2007 Office System Administrative Templates. For more information, see “Excel 2007″ subsection of the “More Information” section.
For Excel 2003, update 933666 enables an administrator to block the ability to save or to open files in Excel 2003.
RESOLUTION
In Excel 2003, there are no trusted locations. You can create an exempt location to override the registry policy settings. To create an exempt location, follow these steps:
| 1. | Exit Excel 2003. |
| 2. | Click Start, click Run, type regedit in the Open box, and then click OK. |
| 3. | Locate and then click to select one of the following registry subkeys:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Common |
| 4. | Point to New on the Edit menu, and then click Key |
| 5. | Type OICEExemptions for the name of the key. |
| 6. | Point to New on the Edit menu, and then click String Value. |
| 7. | Type a string name, and then press ENTER. For example, type ExemptDirectory. |
| 8. | Right-click the string name that you typed in step 7, and then click Modify. |
| 9. | In the Value data box, type the path of the directory that contains the file, and then click OK.Note You must create the folder. Any subfolders are not automatically exempted. For any additional folders that you would like to make exempt, repeat steps 6-9. |
| 10. | On the File menu, click Exit to exit Registry Editor. |
You might not have to do this step but just in case the top part does not work, do this steps too:
To enable the FileOpenBlock subkey settings, follow these steps:
| 1. | Exit Excel. | ||||||
| 2. | 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. | ||||||
| 3. | Click Start, click Run, type regedit in the Open box, and then click OK. | ||||||
| 4. | Locate and then click to select one of the following registry subkeys:Excel 2007
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\FileOpenBlock HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Excel\Security\FileOpenBlock
Excel 2003 HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileOpenBlock HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Security\FileOpenBlock
If the FileOpenBlock subkey does not exist, follow these steps to create it:
|
||||||
| 5. | Point to New on the Edit menu, and then click DWORD Value. | ||||||
| 6. | Type the DWORD name that you want to restrict, and then press ENTER. For example, type BinaryFiles. | ||||||
| 7. | Right-click the DWORD name that you typed in step 6, and then click Modify. | ||||||
| 8. | In the Value data box, type 1, and then click OK. | ||||||
| 9. | On the File menu, click Exit to exit Registry Editor. |












