I have used the data imp[ort wizard to import a CSV. The CSV is updated every 20 seconds and rather than set the worksheet to refresh once a min (which seems to be the most frequent i can set it) i would like it to refresh every 20-30 seconds.

This can be done by setting up a looping macro to do this but i would like the worksheet to refresh whilst also being able to enter data on another sheet.

Can this be done?