Publishing an excel worksheet via Frontpage

[ynissel]

I have a detailed excel spreadsheet - with multiple pages, range names,
formulas and control box objects (check boxes and drop down lists). Is there
any way to get this to be a web page and allow the same functionality to
remain ? interactivity and checkboxes (some formulas are based on results in
the text box so I need it all). I tried the publish function but that didnt
carry over the control boxes, some conditional formatting and I think a few
minor things. IF Excel cant do it - can Front page do this or can anyone
recommend a software package that can ?

Thanks !!
Yosef

 

[Dan L]

You can save the entire workbook as *.htm and most functionality remains in
tact - I'm not sure about the interactivity of drop down lists, though. All
worksheets are navigatable. Here's an example of a saved Excel spreadsheet
(although I can't figure out why the grid lines aren't showing up right now -
they used to)
http://www.qualitybass.org/2005_Standings/Standings_2005.htm

 

[ynissel]

It doesnt save the forms - ie drop down boxes etc.. but thanks for at least
trying !!

 

[Thomas A. Rowe]

You would have to import and link to as a Excel file and your site visitors would have to have
IE/Excel to view directly online.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[ynissel]

Thanks
I guess you are saying to link frontpage to Excell and then all users have
to install something else to allow them to use the excel page. How do I
learn more about this ?
Thanks again,
Yosef

 

[Thomas A. Rowe]

You just import the spreadsheet into your current open FP web, then create a link to it. You will
need to inform users that they must have Excel Installed, and if the spreadsheet allows changes,
they will be saved to the user's HD, not back to the web site.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[ynissel]

Shoots - thats not what I wat. I want them to be able to manipulate it and
then submit the file with the changes back to me (via Email ?)

 

[Thomas A. Rowe]

If they save it to their HD, then they can attach it to an email back to you.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Andrew Murray]

all the users need is the application, "Microsoft Excel" since they would
be essentially downloading and opening the xls file on their machine.

 

[Andrew Murray]

wouldn't be possible - what if say 5 users opened the same file at the same
time, then saved the changes they had made, one would overwrite the other's
changes (if they didn't know what the other person had done).

Person A and Person B open the file (at the same time):

Person A makes 10 changes, saves the file

Person B makes 5 changes to the file (the original copy before Person A
changed it and saved his changes back to the server). then Person B saves
his changes to the server and effectively and completely overwrites Person
A's changes.

etc.

Normally on an internal network, it would detect that two users are trying
to use the same file and would lock it as read-only to one or the other user
(unless the file permissions are set to allow multi-users, but you would
then get the same situation - one would overwrite changes the other has
made.).