For the most part, an overweight rating indicates less about the literal meaning of giving a stock higher weight than a given benchmark. Instead, it's typically used as Wall Street jargon to indicate a positive attitude about a particular stock.
To set an option to automatically refresh PivotTable data when you open your workbook, do the following: 1  Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. 2  Click Analyze > Options. 3  In the PivotTable Options dialog box, on the Data tab, check the Refresh data when opening the file box.
1 Open a new worksheet and type the following data: 2  In versions of Microsoft Excel earlier than Excel 97, click PivotTable on the Data menu. 3  Or, in Excel 97, click PivotTable Report on the Data menu. 4  In the Step 1 dialog box of the PivotTable Wizard, click Microsoft Excel list or database and then click Next.