Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Pivot Tables

Pivot Tables

ResolvedVersion 2003

Thu 19 Feb 2009, 16:36 Delegate Steve said...

Steve has attended:
Excel VBA Intro Intermediate course

Pivot Tables

How to publish pivot tables online - from excel.

Fri 27 Feb 2009, 16:24 Trainer Carlos said...

RE: Pivot Tables

Hi Steve

To publish a pivot table online from Excel you do the following:

1. Open the workbook on the Pivot table sheet

2. Select the File menu and click Save As Web Page

3. Select the option Selection:Sheet to publish just the selected Pivot table sheet

4. Click the Publish button

5. In the Publish As Web page dialog box select the folder where the new file will be saved

6. Add Interactivity if needed

7. Click the Publish button

Hope this helps

Carlos

Thu 5 Mar 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Change the default location for opening and saving spreadsheets