+ Reply to Thread
Results 1 to 3 of 3

Publishing Excel 2010 workbook as an Interactive web page

  1. #1
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,789

    Publishing Excel 2010 workbook as an Interactive web page

    With Excel 2007 I seem to remember that it was trivial to save a workbook as an interactive web page - unfortunately I no longer have 2007 and am on 2010.

    This still allows a static web page to be published but the ability to make it interactive has disappeared - at least I can't find the little check box that used to switch this on.

    I've also tried using Excel 2013 from the on-line MS Office area to no avail.

    Does anyone know how?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    55,021

    Re: Publishing Excel 2010 workbook as an Interactive web page

    Richard - I have 2016, and I don't know how closely it compares to the online 2013 version, but if I go to Export and Save as Other File Type I can choose HTML format. The tools seem to allow me to save a read/write copy. Is that option not there for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,789

    Re: Publishing Excel 2010 workbook as an Interactive web page

    Hello Ali,

    Thanks for the interest.

    Yes indeed that functionality is still there for 2010 and indeed 2013, however what is missing is the all important check box on (I think) the pop up Publish window which says, or said, something along the lines of 'Add Interactivity'.

    All you can do currently is publish a static web page. Before with the interactivity parameter ticked, when the browser opened the Excel .htm file you could do a lot of the stuff that you can do in the Excel App itself. i.e. Sort, filter, pick from drop downs etc.

    That's the functionality I'm looking for but all evidence I've see so far when googling the subject suggests that this was dropped post 2007 - why I have no idea and I find it hard to believe we no longer have such a useful piece of functionality.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Save Excel 2010 Form as an Interactive Web Page - With Functioning Macro?
    By Herman Merman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2014, 12:15 PM
  2. Replies: 0
    Last Post: 09-04-2014, 11:03 PM
  3. Publishing interactive excel (macro-enabled) file into a HTML webpage
    By abishekmouli88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2014, 05:21 PM
  4. Save as web page with interactive features (2010)?
    By yes man in forum Excel General
    Replies: 0
    Last Post: 11-15-2013, 03:27 PM
  5. Replies: 0
    Last Post: 10-14-2011, 06:36 PM
  6. Publishing Excel Report As Interactive Web Page
    By treeantz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2011, 03:38 AM
  7. Excel 2007 : Publishing an interactive sheet to the web
    By SteveW68 in forum Excel General
    Replies: 0
    Last Post: 03-25-2010, 05:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1