I finally figured it out. I used Data - Import External Data - Import Data &
went through all the typical wizard replies. The key seems to be that after
I clicked "Finish" and was prompted to input where I wanted the data imported
to on the worksheet...Before clicking "ok", I clicked on "Properties" then
clicked "OK". It doesn't seem to matter if I've made any changes to the
properties or not. I'm not sure why, but Abracadabra, now I can use "Refresh"
to update the import my data.

Thanks for your response.

"Earl Kiosterud" wrote:

Bean,

It sounds as if you used Data - Get external data. It remembers all the
paramaters you specify, and you have only to do a refresh, and it reads in
the data again. Quite indistinguishable from magic.
--
Earl Kiosterud
www.smokeylake.com

"Bean123r" wrote in message
...
Did ya ever have one of those lucky accidents that you like and would like
to
replicate?

I created a simple excel workbook based on imported text data. Later,
when
I reopended the file, I noticed that the "refresh" button was activated
and
would auto import when I clicked. The best part is that the import specs
were retained.

I have no idea how I did this and have not been able to replicate the
functionality.

Can someone help?

Thanks