Data selection and formatting. 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. Interactive PivotTable list component for Web pages. 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.
You can create and run queries to retrieve data that is available on the World Wide Web. You can either select an entire Web page or specify a table on a Web page to retrieve. Excel 2000 provides several sample Web queries that you can run. Refreshable text import. Data from text files can now be brought into Excel in the same way that you create other database queries.