certain formats blocked after installing Office 2003 Service Pack

R

Ranpalandil

I can not open or save files in Lotus format, eg. wk1, wk3 or wk4, in Excel
since I installed Office 2003 Service Pack 3. I have read the KB article
938810 "Information about certain file formats that are blocked after you
install Office 2003 Service Pack 3" and I looked in my registry for the keys
the article said I need to change.
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileOpenBlock
and
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Security\FileOpenBlock
But those keys are not in my registry. There is not a FileOpenBlock under
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\ and there is
not a Office under HKEY_CURRENT_USER\Software\Policies\Microsoft\
So what do I do now? Thanks for any help.
Bob
 
R

Ranpalandil

Thanks, but this didn't help. I do have the
"HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileOpenBlock"
registry subkey now and with LotusandQuattroFiles and DifandSylkFiles
registry values set to 0, but I still get the "You are attempting to open a
file type that is blocked by your registry policy setting." error message
when I try to open a wk1 file.
Any other suggestions? Thanks.

Bob
 
N

neo [mvp outlook]

Hmm... Try creating the registry value at
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Security\FileOpenBlock
since it overrides the location in the link. Oh, and if you are creating
these registry values with Excel open, you need restart your office app.
 
R

Ranpalandil

Thank you. We are definately making some progress here! Now I can open Lotus
files, but I still can't save in a Lotus format. (I'm trying to save an Excel
file as a wk4) And I did add the FileSaveBlock key as well as the
FileOpenblock key with LotusandQuattroFiles and DifandSylkFiles DWORD values
of 0. Is there something I'm missing yet? Thanks.

Bob
 
B

Baboon

Hi -

I am just concerned with the problem that Word has opening docs created in
prior versions of Word at this point. I had already set FilesBeforeVersion
to 00000000, but that did no good. I added the entire section for Word from
your web page, but that did no good either. I had earlier tried the ADM that
added "Block opening files before version", setting that to Disabled, but it
did no good. Reading further down this thread, it looks like you have to add
all 3 edits. Wow.....

Thanks.
 
B

Baboon

OK, apparently for my Word problem, I just needed to do the FileOpenBlock and
FileSaveBlock. I added all the entries that you posted for each, so I don't
know if simply using "FilesBeforeVersion" would have been enough (it probably
would). I also had added ExemptDirectory, but apparently that wasn't needed
as I discovered by mistake.

It's kind of a drag that the Office 2003 SP3 ADM doesn't include
"FilesBeforeVersion" in the FileSaveBlock settings, only in FileOpenBlock.

Thanks much.
 
R

Ranpalandil

Yes, I did. And I still can't save to a Lotus format even in the supposedly
exempt directory. Other Ideas?
 
M

moxiebald

Here is what finally worked for me:


HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Common
\OICEExemptions
ExemptDirectory=c:\Safe (String)

and

HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel
\Security\FileSaveBlock
LotusandQuattroFiles=00000000 (DWORD)
 
J

jminkle

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 --------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top