How refresh imported data automatically?

R

Ronald S. Cook

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
 
B

Beege

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
 
Top