Excel and the web
 

I have created an active sql excel spredsheet that i am unable to just
publish as it does not work. but i need it to be able to be changed from the
intranet and for the new results to be displayed on the web. How can i do
this? when using the excel publish button it does not enable my variables to
effect the SQL Query. I have administrator rights on the sql server and the
web server. Please help
Nathan