financial excel course london - Pivot Table

Hi Chitra

Thank you for your question.

You can create a web page which contains a pivot table, with some pivot table functionality that the web page viewers can use if you wish.

Bring up the sheet containing your pivot table, then go to File - Save as web page. Give the file a name, and tick the Add interactivity box if you want functionality available on the web page. Click the Publish button. Then tick the box Add interactivity with and select Pivot table functionality if you want interactivity. Tick the Open Published web page in browser and click Publish to view your web page.

Amanda