How do I get a stock quote updated automatically in excel 2000?
 

I know I am supposed to use the web query function, but whenever I try and
use the web query that came with Office 2000, it fails and if I build one on
my own, it fails as well. The message I get is a pop op window in Excel that
says "The internet site reports a connection was established but the data is
not available."