How refresh imported data automatically?

In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
automated way.

Is there some sort of macro I can write when opened or something?

Thanks,
Ron

Ron,

Select the cell the data starts in, select Data/Import External Data/Data
Range Properties

Check the box "Refresh on file open" and anything else that needs checking
off...

Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.

Beege




"Ronald S. Cook" <[email protected]> wrote in message
news:[email protected]...
> In Excel, I've imported data into a worksheet. I know I can click Data..
> Refresh Data to requery the source, but I want to be able to do it in a
> more automated way.
>
> Is there some sort of macro I can write when opened or something?
>
> Thanks,
> Ron
>
>

Where is this "Refresh on file open" checkbox, please?


"Beege" <[email protected]> wrote in message
news:[email protected]...
> Ron,
>
> Select the cell the data starts in, select Data/Import External Data/Data
> Range Properties
>
> Check the box "Refresh on file open" and anything else that needs checking
> off...
>
> Other than that, you could record a new Macro that selects your cell,
> refreshes data, and assign the macro to a keystroke, or even an icon.
>
> Beege
>
>
>
>
> "Ronald S. Cook" <[email protected]> wrote in message
> news:[email protected]...
>> In Excel, I've imported data into a worksheet. I know I can click Data..
>> Refresh Data to requery the source, but I want to be able to do it in a
>> more automated way.
>>
>> Is there some sort of macro I can write when opened or something?
>>
>> Thanks,
>> Ron
>>
>>
>
>

Nevermind.. found it.

"Ronald S. Cook" <[email protected]> wrote in message
news:%[email protected]...
> Where is this "Refresh on file open" checkbox, please?
>
>
> "Beege" <[email protected]> wrote in message
> news:[email protected]...
>> Ron,
>>
>> Select the cell the data starts in, select Data/Import External Data/Data
>> Range Properties
>>
>> Check the box "Refresh on file open" and anything else that needs
>> checking off...
>>
>> Other than that, you could record a new Macro that selects your cell,
>> refreshes data, and assign the macro to a keystroke, or even an icon.
>>
>> Beege
>>
>>
>>
>>
>> "Ronald S. Cook" <[email protected]> wrote in message
>> news:[email protected]...
>>> In Excel, I've imported data into a worksheet. I know I can click
>>> Data.. Refresh Data to requery the source, but I want to be able to do
>>> it in a more automated way.
>>>
>>> Is there some sort of macro I can write when opened or something?
>>>
>>> Thanks,
>>> Ron
>>>
>>>
>>
>>
>
>