Security Warning

[John Persico]

When I go into my Excel file it says: Security Warning Automatic update of
links has been disabled.

How can I make it so that this message doesn't not show up and the data
automatically loads (I'm linking to data in other files).

--

 

[Héctor Miguel]

hi, John !

When I go into my Excel file it says: Security Warning Automatic update of links has been disabled.
How can I make it so that this message doesn't not show up and the data automatically loads (I'm linking to data in other files).

and... your excel version is... (?)
does this help ?
=> http://support.microsoft.com/kb/925893

hth,
hector.

 

[John Persico]

Excel 2007

--

hi, John !


and... your excel version is... (?)
does this help ?
=> http://support.microsoft.com/kb/925893

hth,
hector.

 

[John Persico]

No, that didn't help.
Any other ideas?

--

hi, John !


and... your excel version is... (?)
does this help ?
=> http://support.microsoft.com/kb/925893

hth,
hector.

 

[Héctor Miguel]

hi, John !

No, that didn't help.
Any other ideas?

well, the kb-article is full of (possible) alternates and options to check
and it applies precisely to xl-2007 (at the top is a link to previous versions: kb-327006)

there might be other ways, but...
how could it be possible to (RE)build an exact model and environment as yours ?

- workbooks created in xl-2007 ?... or in (which) previous version ?
- what are your settings (2007) regarding macro and external links warnings ?
- what did you choose at "first-time" question regarding external links while first save/open linked wb ?

regards,
hector.

__ previous __

 

[John Persico]

I changed the External Content to "Enable automatic update..." on the
security settings for Workbook Links and now I don't get the message.
Thanks for your help.