98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Excel advanced
excel training class - Excel advanced
Resolved · Low Priority · Version Standard
RE: excel advanced
Hi Aristos
Thank you for your question.
You can save a spreadsheet displaying a pivot table as an html file, which can include interactivity so a person can modify the pivot table once the html file is posted on a web site.
You can do this by going to File - Save as Web Page. Choose to save the sheet, then you can tick the Add interactivity check box if you want people to be able to manipulate the pivot table. Then click the Publish button on the right. Choose to add Pivot Table functionality if you selected the check box in the previous dialogue box. Then choose the Open web page in browser box if you want to preview the html file in a web browswer, the click Publish.
Once this is done, you will need to upload the page to a web site if you want people to be able to access this page through the WWW.
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |