Hi,

My workbook contains many links to other files - all on my PC. Links to
files in the same directory open without a warning. But links to files in
other directories do not open until one says OK to a warning ("some files can
contain viruses ..."). I cannot store all files in the same directory but do
not want to have to say OK to open any files.
Is there any way to disable this warning? Can't find anything in Help or
under Tools/Options/Security.

Eugene

See:

http://support.microsoft.com/Default.aspx?kbid=829072
--
Gary''s Student - gsnu200752


"eugene" wrote:

Hi,

My workbook contains many links to other files - all on my PC. Links to
files in the same directory open without a warning. But links to files in
other directories do not open until one says OK to a warning ("some files can
contain viruses ..."). I cannot store all files in the same directory but do
not want to have to say OK to open any files.
Is there any way to disable this warning? Can't find anything in Help or
under Tools/Options/Security.

Eugene

Thanks.

Quite scary though - both the way it has to be done and the fact that it
affects hyperlinks to all files.

Surprising that this can't be done in an easier way and/or just for local
files or just for Excel.

Eugene


"Gary''s Student" wrote:

See:

http://support.microsoft.com/Default.aspx?kbid=829072
--
Gary''s Student - gsnu200752


"eugene" wrote:

Hi,

My workbook contains many links to other files - all on my PC. Links to
files in the same directory open without a warning. But links to files in
other directories do not open until one says OK to a warning ("some files can
contain viruses ..."). I cannot store all files in the same directory but do
not want to have to say OK to open any files.
Is there any way to disable this warning? Can't find anything in Help or
under Tools/Options/Security.

Eugene

I agree with you.

Why not post a suggestion to Microsoft on this issue ?
--
Gary''s Student - gsnu200752


"eugene" wrote:

Thanks.

Quite scary though - both the way it has to be done and the fact that it
affects hyperlinks to all files.

Surprising that this can't be done in an easier way and/or just for local
files or just for Excel.

Eugene


"Gary''s Student" wrote:

See:

http://support.microsoft.com/Default.aspx?kbid=829072
--
Gary''s Student - gsnu200752


"eugene" wrote:

Hi,

My workbook contains many links to other files - all on my PC. Links to
files in the same directory open without a warning. But links to files in
other directories do not open until one says OK to a warning ("some files can
contain viruses ..."). I cannot store all files in the same directory but do
not want to have to say OK to open any files.
Is there any way to disable this warning? Can't find anything in Help or
under Tools/Options/Security.

Eugene

Have a look at this KB Article for disabling that "some files may contain
viruses" message in Office 2003

http://support.microsoft.com/kb/829072/en-us


Gord Dibben MS Excel MVP

On Tue, 30 Oct 2007 06:59:10 -0700, eugene
wrote:

Hi,

My workbook contains many links to other files - all on my PC. Links to
files in the same directory open without a warning. But links to files in
other directories do not open until one says OK to a warning ("some files can
contain viruses ..."). I cannot store all files in the same directory but do
not want to have to say OK to open any files.
Is there any way to disable this warning? Can't find anything in Help or
under Tools/Options/Security.

Eugene