Updating external data tables
 

Hello,
Using WinXP and Xl-2007;
I've tried to format a table where there is an external link (from text) but
it seems Excel does not allow that.
Is there a way to refresh the data in a defined table with an external data
link?
I'd prefer not to use a macro but will try it if it's the only way.
Thank you for any advice.

David K.