Refresh Data
 

I have a spreadsheet that will have 10 to 12 different data sources.
Can I refresh all the data sources at once? or do I have to do them
individually?

Thanks in advance

Refresh Data
 

Doug,

ThisWorkbook.RefreshAll

Cheers, Pete

-----Original Message-----
I have a spreadsheet that will have 10 to 12 different
data sources.
Can I refresh all the data sources at once? or do I have
to do them
individually?

Thanks in advance

Refresh Data
 

OK. That works great.

I have a follow-up situation.

There might be an easier way to do this, I am not sure.

I have a worksheet, that is just another XLS spreadsheet that I refresh. It
was "imported".
When I refresh that data, the entries that contain only numbers in a certain
column do not come across. The entries that contain letters in the same
column come across. They are being lost on the import.


"Pete McCosh" wrote in message
...
Doug,

ThisWorkbook.RefreshAll

Cheers, Pete

-----Original Message-----
I have a spreadsheet that will have 10 to 12 different
data sources.
Can I refresh all the data sources at once? or do I have
to do them
individually?

Thanks in advance