How to Publish Interactive Excel Pivot Table and Data Table in webpage format

[jintingljw]

Hi all, I recently get a job task to publish interactive excel pivot table and data table in the format of webpage so my colleague can access the reports and do simple sort and filter through intranet without downloading and opening an Excel. I have did a lot of research as below but cannot find the right solution for my needs. I appreciate if someone can give me any researching directions to achieve my goal.

Option 1: the Excel build-in function – Save as Webpage. This function is nice and easy to publish the excel report in webpage format. However, it seems the “Interactive” option is not available for any version of Excel released after the 2007 version – when we open the dialog box of “Saving as webpage”, there is no “Interactive” button available to select in Excel 2010 or 2013.

Missing "Add Interactivity" When Saving Excel Spreadsheet as - Microsoft Community




Option 2: Skydrive or Onedrive – upload the Excel workbook into Skydrive or Onedrive. Once it is uploaded, the Skydrive or Onedrive will provided a HTML code represent your excel workbook ( refer below tutorial to get the HTML code), so you can embed your HTML code into blog or forume to pulish your Excel data interactively. However, due to company document security concern, I won’t consider this method, since I have to use my personal OneDrive account in this method ( there is not company OneDrive account available).

How to embed an interactive Excel spreadSheet in wordpress or any other web page