when using windows authentication you need to give each user rights on the machine. I think the other option is to use impersionation..
That said, if your creating a basic sheet- there is no need to use the excel object- you can change the header and send a table over, and the browser will open it in excel (which the user can then save).
Web Developer, PDI Inc.
NOT a Wiley/Wrox Employee