Certain file formats blocked after installing Office 2003 Service Pack
I am not able to work with some file format in Microsoft Office 2003 after applying a SP3 patch. The update was fine and there were no error. Before that I use to view lotus file format in Excel. They were wk1, wk3, etc. But after installation of the update I cannot see any of them opening up in Excel. The formats are blocked by Office update. I found a registry tweak that also did not helped much. I had changed that the keys of FileOpenBlock key located under HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\. And another one located under HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Security. But that did not helped much. The below kb article also did not helped much in fixing the issue.
Information about certain file types that are blocked after you install Office 2003 Service Pack 3
Re: certain formats blocked after installing Office 2003 Service P
I just required a way by which I can simply create or open Lotus flies in Word. This was fine with older version but after upgrade I am not able to work on the same. This formats are blocked and I do not understand those registry tweaks.
Tips for Importing Lotus 1-2-3 Files to Excel
HOW TO: Export Lotus 1-2-3 Linked Files to Excel 2000
re: Certain file formats blocked after installing Office 2003 Service Pack
I created a .reg file with the following to solve this problem (note that there should not be spaces in the words Excel or Office - the forum software put those there, also I think the contents inside the []'s are meant to be on one line):
----- start of file allow_wks.reg --------
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileOpenBlock]
"LotusandQuattroFiles"=dword:00000000
[HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Security\FileOpenBlock]
"LotusandQuattroFiles"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileSaveBlock]
"LotusandQuattroFiles"=dword:00000000
[HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Security\FileSaveBlock]
"LotusandQuattroFiles"=dword:00000000
----- end of file allow_wks.reg --------