Protection of Interactive Excel Spread Sheet on the Web

[Spurs]

Does anyone know of a way to be able to make an Excel worksheet visible on a web page, but at the same time not having to unlock and unprotect the formulas and code in each of the cells?

Does this require the use of a server or "dummy" excel web page?

 

[magicme]

In EXCEL you can SAVE FILE AS > HTML and check "add operability".
That will save the file as an HTML document.

However in order for someone to operate the spreadsheet in a web browser they must use IE and the microsoft web components (downloadable I think from microsoft).

Theoretically it should work that way (I have never done it, as I use Javascript for that purpose).

regards

 

[johnwm]

I believe that the end user will need a licensed copy of Excel on their machine for the spreadsheet to actually work

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[Spurs]

I am familar with the save as html capability - however it does not work unless you unlock and unprotect all of the cells - thereby allowing the user to see the coding, and allowing the user to save the speadsheet on his system.

Anyone have any other thoughts?

 

[magicme]

i am pretty certain that the only way you can get web-operability plus code security is to keep your calculation routine (as a script file) on the web server and use a javascript in your HTML web page (that is on the user's computer via his/her web browser) and to reference the script by way of a button on your web page.

of course you have to ask your ISP if he'll allow you to allow users to execute programs on his server.

i don't think a simple spreadsheet solution exists.

if you find one.... PLEASE post your findings here.

regards.