Automatic data refresh

[sjgoodwin]

Hello,

I have external data refreshing in my spreasheet every one minute (as this is the lowest refresh time available in the options box)

Does anyone know if these settings can be changed so that my external data is refreshed every 5 seconds?

I would appreciate any help.

Thanks

Steve

[Carim]

Hi,

Every half second ... if need be ...

Excellent explanation is available at Chip's site

http://www.cpearson.com/excel/ontime.htm

HTH
Carim