Save Excel file as HTML with user input fields

I know that Excel allows me to save my file as an HTML file. I have a spreadsheet with data pulled from MS Query (datawarehouse tables). In cell A1 I have a parameter input value where the user can input the value and the query will refresh automatically pulling the correct data.

Is it possible to save the file as HTML, then for cell A1 to still be an variable user input value, and the data to update on the page? I know it's possibly using tools like SQL Server, etc, but I'm hoping to create reports that I can publish to our intranet website that users can use, plus by me creating these it's much faster than submitting a request to our programmers as they are backed up with so many requests as it is.

I've tried publishing the Excel file to HTML and I see the data, but that's it - I can only see the hard-coded data and it's not a dynamic report any more.

Thanks. Sorry, I should have mentioned that I'm using Excel 2007 so this doesn't apply. From what I've found now based on your info, Excel 2007 uses Excel Services and Sharepoint so I've got some research and learning ahead of me.