I have an MS Excel 2007 workbook (*.xlsx format) that consists of one worksheet with an embedded chart on that worksheet, and frozen panes ("View -> Window -> Freeze Panes"). If I also then save it in HTML format (to put on the web), it will be merely a static display of numbers and a picture (of the chart) and the columns & rows that should be frozen (on the left and top) are not.



Is there a way of saving that workbook in an HTML (or other web-friendly) format, and having it

a) provide some interactive calculations on the web?

b) retain formating such as the same pane-freezing effect?

i.e., I want the person who is looking at this web-based spreadsheet on their browser to have the capacity to change the contents of SOME cells (but not others) and the chart will get updated in real time (only the cells and chart copy that resides on their browser; my original copy still resides wherever I host the webpage). In such an application I'd probably lock the "calculation" cells but keep the "data" cells edit-able (un-locked) on the *.xlsx document and want those same cell-specific locked/unlocked attributes to remain with the HTML (or other web-friendly) based version.

Yes, I know I can upload the *.xlsx / *.xls documents to the website and provide hyperlinks (in the HTML) for users to download copies of the *.xlsx / *.xls files and do with them what they want, but that requires they have Excel. I'm looking to make an executable web-based Excel for those who don't have such a license. It's not hard to imagine that Microsoft would like some fee for this or for such developers to pay for a Professional level of MS Office, and I'm ok with that. Just want to know if it's do-able.

you can use Microsoft Office SharePoint Server 2007 , or click the office button-publish, or
CHECK THIS:http://office.microsoft.com/en-us/ex...Mcollaboration