I have a spreadsheet I created in Office 07. It uses drop down lists to
compile pricing for various products, basically an estimator of sorts. I
wanted to try and save this as a web page so that the end user (my customer)
can use the drop down boxes and enter various info to compile their own
prices.
I'm having trouble figuring out how to do this. I can publish as a webpage
but it doesn't allow any modifications. Is what I'm trying to accomplish
do-able or am I just flat out using the wrong process/programs?
Thanks for any help.
KJ

Publishing it as a web page on its own won't work. I would publish a link to
the document, and make all of the worksheet protected except for the cells
which the customer is editing. Instruct customers to complete the worksheet,
save it on their machine, and email it to you.

"KJ" wrote:

I have a spreadsheet I created in Office 07. It uses drop down lists to
compile pricing for various products, basically an estimator of sorts. I
wanted to try and save this as a web page so that the end user (my customer)
can use the drop down boxes and enter various info to compile their own
prices.
I'm having trouble figuring out how to do this. I can publish as a webpage
but it doesn't allow any modifications. Is what I'm trying to accomplish
do-able or am I just flat out using the wrong process/programs?
Thanks for any help.
KJ

Hi. I am doing more or less the same thing. But in addtion to drop down list,
I also use the form control, such as check box and option button. It is
basically an ordering form where customer can order items by clicking the
check boxes related to items they want to order, and I want to put that form
in the company website. Is it possible to publish such thing to a web page?
and if it is, could anyone help me step by step of how to do such thing?

Thank you very much for your help.

"Lauren Giles" wrote:

Publishing it as a web page on its own won't work. I would publish a link to
the document, and make all of the worksheet protected except for the cells
which the customer is editing. Instruct customers to complete the worksheet,
save it on their machine, and email it to you.

"KJ" wrote:

I have a spreadsheet I created in Office 07. It uses drop down lists to
compile pricing for various products, basically an estimator of sorts. I
wanted to try and save this as a web page so that the end user (my customer)
can use the drop down boxes and enter various info to compile their own
prices.
I'm having trouble figuring out how to do this. I can publish as a webpage
but it doesn't allow any modifications. Is what I'm trying to accomplish
do-able or am I just flat out using the wrong process/programs?
Thanks for any help.
KJ