Can a spreadsheet be saved as interactive webpage
 

How is it possible to save a spreadsheet / workbook as an interactive webpage
in office 2007 that can be used online

Can a spreadsheet be saved as interactive webpage
 

El Plate;417307 Wrote:
How is it possible to save a spreadsheet / workbook as an interactive
webpage
in office 2007 that can be used online

If I understand your question correctly, in Excel 2007, press Alt+F+A,
in the SaveAs window, select the "Save as type" as "web page", you have
the option to select the entire workbook or worksheet, click on Publish,
check the option "Open published webpage in browser" and click on
Publish.

I have not tested this resolution at my end though.


--
Stormseed
------------------------------------------------------------------------
Stormseed's Profile: http://www.thecodecage.com/forumz/member.php?userid=515
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116131

Can a spreadsheet be saved as interactive webpage
 

"Stormseed" wrote:


El Plate;417307 Wrote:
How is it possible to save a spreadsheet / workbook as an interactive
webpage
in office 2007 that can be used online

If I understand your question correctly, in Excel 2007, press Alt+F+A,
in the SaveAs window, select the "Save as type" as "web page", you have
the option to select the entire workbook or worksheet, click on Publish,
check the option "Open published webpage in browser" and click on
Publish.

I have not tested this resolution at my end though.


--
Stormseed
------------------------------------------------------------------------
Stormseed's Profile: http://www.thecodecage.com/forumz/member.php?userid=515
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116131

------------------------------------------------------------------------

Hello Stormseed
Thank you for a swift reply
I tried your suggestion prior to posting for help and the method you point
out will only save a static web page which does not allow any cell
integration.

I was hoping to put up an html page online where users can input criterea
into a cell to obtain a result

hope this makes sense.
regards
El Plate

Can a spreadsheet be saved as interactive webpage
 

When saving as web page all you need to do to make this happen is to
select the *Add Interactivity check box* in the Save As dialog box at
the time you save the worksheet as a Web page*.*El Plate;418108 Wrote:
"Stormseed" wrote:


El Plate;417307 Wrote:
How is it possible to save a spreadsheet / workbook as an
interactive
webpage
in office 2007 that can be used online

If I understand your question correctly, in Excel 2007, press
Alt+F+A,
in the SaveAs window, select the "Save as type" as "web page", you
have
the option to select the entire workbook or worksheet, click on
Publish,
check the option "Open published webpage in browser" and click on
Publish.

I have not tested this resolution at my end though.


--
Stormseed

------------------------------------------------------------------------
Stormseed's Profile: 'The Code Cage Forums - View Profile: Stormseed'
(http://www.thecodecage.com/forumz/member.php?userid=515)
View this thread: 'Can a spreadsheet be saved as interactive webpage
- The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=116131)


------------------------------------------------------------------------

Hello Stormseed
Thank you for a swift reply
I tried your suggestion prior to posting for help and the method you
point
out will only save a static web page which does not allow any cell
integration.

I was hoping to put up an html page online where users can input
criterea
into a cell to obtain a result

hope this makes sense.
regards
El Plate


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116131