Automatic refresh of external data

I've looked and played with all the settings that I think would allow
automatic refresh of external data, but I still get a dialog box every time
I open the workbook that asks if I really want to enable or disable
automatic refresh. Yes I really do! Where is the switch or property which
automatically enables this?

TIA

Keith

BTW I using 2003.

I assume I'm the only one with this problem.

"Keith Streich" <[email protected]> wrote in message
news:[email protected]...
> I've looked and played with all the settings that I think would allow
> automatic refresh of external data, but I still get a dialog box every
time
> I open the workbook that asks if I really want to enable or disable
> automatic refresh. Yes I really do! Where is the switch or property
which
> automatically enables this?
>
> TIA
>
> Keith
>
>

Keith

No your not, I'm on 2002 an can't get it too auto refresh on open either,
maybe its only us two are having the problem

"Keith Streich" <[email protected]> wrote in message
news:[email protected]...
> I assume I'm the only one with this problem.
>
> "Keith Streich" <[email protected]> wrote in message
> news:[email protected]...
> > I've looked and played with all the settings that I think would allow
> > automatic refresh of external data, but I still get a dialog box every
> time
> > I open the workbook that asks if I really want to enable or disable
> > automatic refresh. Yes I really do! Where is the switch or property
> which
> > automatically enables this?
> >
> > TIA
> >
> > Keith
> >
> >
>
>

I was really hoping to get some type of solution from this group.

"Keith Streich" <[email protected]> wrote in message
news:[email protected]...
> I've looked and played with all the settings that I think would allow
> automatic refresh of external data, but I still get a dialog box every
time
> I open the workbook that asks if I really want to enable or disable
> automatic refresh. Yes I really do! Where is the switch or property
which
> automatically enables this?
>
> TIA
>
> Keith
>
>