- Dec 12, 2000
- 25,627
- 10,330
- 136
Okay, here's what I'm trying to do.
I have created a nifty little tool for a new marketing campaign at my company. Right now, the tool exists as a MS Excel worksheet. The main sheet contains questions that a potential client would be able to answer by clicking on radio buttons. As the client clicks away, the sheet is actually calculating the client's need for our product based on their input. This is all done in hidden cells etc. so the client doesn't see the calculation/formulas of course--they just see a clean, simple survey. When the client is done, they can click the tab for the 2nd sheet, which shows them their need for our product graphically (based on the calculations, their need will be graphed as high or low in two dimensions.)
Now how do I retain all this functionality in converting this to a web-based tool? The 'Publish as Web' option in Excel doesn't do it (I am using the latest Excel XP with SP1.) Even when I click 'add interactivity' it doesn't work (it just lets me scroll the sheet, but the radio buttons don't even show up!)
Any suggestions?
I have created a nifty little tool for a new marketing campaign at my company. Right now, the tool exists as a MS Excel worksheet. The main sheet contains questions that a potential client would be able to answer by clicking on radio buttons. As the client clicks away, the sheet is actually calculating the client's need for our product based on their input. This is all done in hidden cells etc. so the client doesn't see the calculation/formulas of course--they just see a clean, simple survey. When the client is done, they can click the tab for the 2nd sheet, which shows them their need for our product graphically (based on the calculations, their need will be graphed as high or low in two dimensions.)
Now how do I retain all this functionality in converting this to a web-based tool? The 'Publish as Web' option in Excel doesn't do it (I am using the latest Excel XP with SP1.) Even when I click 'add interactivity' it doesn't work (it just lets me scroll the sheet, but the radio buttons don't even show up!)
Any suggestions?
