I create input fields using the drawing toolbar. They do not work.

Input cells are created by using one or more cells in the sheet. You cannot use the drawing toolbar.

Build live website calculators and web forms now!

conversion imageconversion imageconversion image

Just download, install and test the Excel add-on now. Or let us convert a spreadsheet for you, for free.