Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training class - excel advanced

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Excel advanced

excel training class - Excel advanced

ResolvedVersion Standard

Aristos has attended:
Excel Advanced course

Excel advanced

How can i post pivot tables on web pages?

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

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.