I am fairly new to creating interactive worksheets in Excel. I want to create an order form with a list of products and there are two columns at the end of the product information where they can choose quantity and the next field is where it calculates the total price. I have all the main parts secure so that no one can edit them and the only two fields that are open to editing are the quantity and total price fields and the place where they fill in their name/address/phone. We have over 500 products so this worksheet is 15 pages long. I don't know how to share this file with customers so they can fill it out and email it back to us. Every time I send it, the receiver is unable to fill in the fields that need to be filled in. I would love to send it in pdf format but it doesn't work either. None of the fields can be filled in when in PDF form. Help would be appreciated! Is there a tutorial somewhere?
