certain formats blocked after installing Office 2003 Service Pack

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

http://msmvps.com/blogs/bradley/arch...word-2003.aspx
should be helpful.

"Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
>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

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

"neo [mvp outlook]" wrote:

> http://msmvps.com/blogs/bradley/arch...word-2003.aspx
> should be helpful.
>
> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
> >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
>
>
>

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.


"Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
news:F16CF355-F7AF-42C0-8821-CDDE114C2D3C@microsoft.com...
> 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
>
> "neo [mvp outlook]" wrote:
>
>> http://msmvps.com/blogs/bradley/arch...word-2003.aspx
>> should be helpful.
>>
>> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
>> news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
>> >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
>>
>>
>>

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

"neo [mvp outlook]" wrote:

> 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.
>
>
> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> news:F16CF355-F7AF-42C0-8821-CDDE114C2D3C@microsoft.com...
> > 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
> >
> > "neo [mvp outlook]" wrote:
> >
> >> http://msmvps.com/blogs/bradley/arch...word-2003.aspx
> >> should be helpful.
> >>
> >> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> >> news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
> >> >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
> >>
> >>
> >>
>
>
>

In reading http://support.microsoft.com/kb/922848, looks like one might need
the FileOpenBlock, FileSaveBlock and OICEExemptions. Did you create this
last one as well?

"Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
news:FEE79B86-2514-4592-A629-2D2F1F20D453@microsoft.com...
> 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
>
> "neo [mvp outlook]" wrote:
>
>> 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.
>>
>>
>> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
>> news:F16CF355-F7AF-42C0-8821-CDDE114C2D3C@microsoft.com...
>> > 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
>> >
>> > "neo [mvp outlook]" wrote:
>> >
>> >> http://msmvps.com/blogs/bradley/arch...word-2003.aspx
>> >> should be helpful.
>> >>
>> >> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
>> >> news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>

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.

"neo [mvp outlook]" wrote:

> http://msmvps.com/blogs/bradley/arch...word-2003.aspx
> should be helpful.
>
> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
> >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
>
>
>

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.

"neo [mvp outlook]" wrote:

> In reading http://support.microsoft.com/kb/922848, looks like one might need
> the FileOpenBlock, FileSaveBlock and OICEExemptions. Did you create this
> last one as well?
>
> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> news:FEE79B86-2514-4592-A629-2D2F1F20D453@microsoft.com...
> > 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
> >
> > "neo [mvp outlook]" wrote:
> >
> >> 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.
> >>
> >>
> >> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> >> news:F16CF355-F7AF-42C0-8821-CDDE114C2D3C@microsoft.com...
> >> > 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
> >> >
> >> > "neo [mvp outlook]" wrote:
> >> >
> >> >> http://msmvps.com/blogs/bradley/arch...word-2003.aspx
> >> >> should be helpful.
> >> >>
> >> >> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> >> >> news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
> >> >> >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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

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

"neo [mvp outlook]" wrote:

> In reading http://support.microsoft.com/kb/922848, looks like one might need
> the FileOpenBlock, FileSaveBlock and OICEExemptions. Did you create this
> last one as well?
>
> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> news:FEE79B86-2514-4592-A629-2D2F1F20D453@microsoft.com...
> > 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
> >
> > "neo [mvp outlook]" wrote:
> >
> >> 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.
> >>
> >>
> >> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> >> news:F16CF355-F7AF-42C0-8821-CDDE114C2D3C@microsoft.com...
> >> > 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
> >> >
> >> > "neo [mvp outlook]" wrote:
> >> >
> >> >> http://msmvps.com/blogs/bradley/arch...word-2003.aspx
> >> >> should be helpful.
> >> >>
> >> >> "Ranpalandil" <Ranpalandil@discussions.microsoft.com> wrote in message
> >> >> news:2EA94A06-E9C6-4F40-9259-EEF60417A613@microsoft.com...
> >> >> >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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

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)

I have those already!

"moxiebald@hotmail.com" wrote:

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

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