Saving as Webpage with Formulas

[CherryxDarling]

Ok so me and my boss have been trying to figure this out for quite some time so maybe someone else can help us out.

We have a spreadsheet that contains a table with a bunch of formulas. It's going to be used to calculate the # of bathrooms, toilets, sinks, etc. that are needed for certain types of buildings. So anyone with the spreadsheet can enter a # in one of the empty cells and it will give them the #'s I expressed above.

Now my question: Is there a way to save the document as a webpage that will allow the users to still enter information into these cells and maintain all the fomulas?

When I've tried to save it as a webpage in the past, it saves it just fine but I'm not able to enter any #'s in the empty cells.

Thanks in advance!

 

[Andrew Poulsom]

This may help you:

http://office.microsoft.com/en-us/e...eb-using-excel-and-frontpage-HA001055277.aspx

 

[CherryxDarling]

This may help you:

http://office.microsoft.com/en-us/e...eb-using-excel-and-frontpage-HA001055277.aspx

The article seems to be exactly what I'm looking for, however, when I try to click on the steps it says the webpage is unavailable .

 

[Andrew Poulsom]

The feature has been deprecated in Excel 2007:

http://office.microsoft.com/en-us/e...0198895.aspx?pid=CH100648071033#BMfileformats

You have to use Sharepoint and Excel Services:

http://office.microsoft.com/en-us/s...s-and-excel-web-access-HA010105476.aspx?CTT=3