perhaps using Data=External Data and create a query in the worksheet using
ODBC. Use an SQL query that returns the single value you want.

The properties of the querytable can be set to control refreshing although I
am not sure about continuously - but periodically as I recall. You probably
want to reject the option to allow a backgroundquery.


--
Regards,
Tom Ogilvy



"Spudanator" wrote in message
...
Currently I am trying to link my excel spreadsheet with a SQL database.
what
i want setup is so that the cell is linked to a specific cell in the
database
and is continually updated. is this possible.. if not how do i create a
macros button to allow me to refresh when required. Thankyou for your
assistance.