MrExcel Publishing
Your One Stop for Excel Tips & Solutions

XL2000 Enhancements

Posted by Dean Pletts on July 26, 2001 3:59 AM

Where can I find out what enhancements have been made from XL97 to XL2000 in particular with regard to pivot tables?

Posted by Ivan F Moala on July 26, 2001 4:03 AM

From online help | Whats new
I got the following;
PivotTable features
Lay out reports directly on worksheets (New in 2000) After you click Finish in the PivotTable and PivotChart Report Wizard, blue outlined drop areas appear on your worksheet and the PivotTable toolbar displays a list of the fields from your source data. You can lay out the PivotTable report directly on the worksheet by dragging the fields from the toolbar to the drop areas.

PivotChart reports (New in 2000) The new PivotChart report brings the power of PivotTable reports to your charts. PivotChart reports are interactive and have field buttons that you can use to show and hide items in a chart.

Indented formats (New in 2000) You can specify that a PivotTable report appear in an indented format — similar to traditional banded or formatted database reports — which makes a large or complex PivotTable report easier to read.

PivotTable AutoFormats (New in 2000) You can use PivotTable AutoFormats to display indented and nonindented PivotTable reports, and you can set PivotTable print options to set page breaks and repeat row and column labels for PivotTable reports that appear in an indented format.

Display and hide items in fields (New in 2000) Row and column fields now have field drop-down arrows . Click the arrows to display and select from a list of available items. The list provides a quick way to show and hide items in fields.

Data selection and formatting (Improved in 2000) You no longer have to use PivotTable selection when you format a PivotTable report. Formatting that you apply by using regular Excel selection is retained when you refresh or change the layout.

OLAP source data (New in 2000) You can create PivotTable reports from OLAP databases and create OLAP cubes from your queries for other databases. OLAP databases and cubes organize the data for PivotTable reports, making it faster to retrieve and update data than when using traditional databases.

Interactive PivotTable list component for Web pages (New in 2000) You can make a PivotTable report available on a Web page as a PivotTable list, which is a component that lets users interact with the data in the Web browser. Users can also refresh the data, change the layout, and select different items for display.