Post Excel form to web -- how?

BlackieHamel

Board Regular
Joined
May 9, 2014
Messages
91
I am using Excel to create a simple calculator, which uses only the PMT function and takes three inputs. I want it to be available to my co-workers on a website, and I want the interface to resemble a web calculator rather than an Excel worksheet. I know I can use forms for this, and I could also create an executable file with an .xlsm workbook.

My question is, what's a simple way to host this calculator on a web page? If I have (1) an Excel form or (2) an executable file, which is easier to put online? I'm not a Web jock, so I'm assuming I'll look for something like Google Sites to create a page. Another thought is to put the executable in a public folder in my Dropbox. But is there an even more straightforward way I can do this? Thanks for any advice.

Blackie
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
A simple solution is to create the workbook in Google Docs: Sheet and "share" it with all or specific people. It will still look like a spreadsheet, but You can adjust the formatting to minimize that.

I think Microsoft has something similar called Office Online
 
Last edited:
Upvote 0
Thanks. I had thought of Google Sheets, but it doesn't seem to have a robust Excel-like Forms option, and I really don't want this to look like a spreadsheet. I will investigate Office Online.

A simple solution is to create the workbook in Google Docs: Sheet and "share" it with all or specific people. It will still look like a spreadsheet, but You can adjust the formatting to minimize that.

I think Microsoft has something similar called Office Online
 
Upvote 0

Forum statistics

Threads
1,203,633
Messages
6,056,450
Members
444,866
Latest member
cr130

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top