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.
Step by step instruction to create a pivot table. Start Microsoft Excel 2007 and open a new document. On the Insert tab, click the PivotTable button in the Tables group. The 'Create PivotTable' wizard appears.Choose one of two options under 'Choose the data that you want to analyze': Select a table or range. This option requires the data to be available in the current Excel workbook.Since you started with a new document in step 1, you first need to import the data from the PMPRO_PIVOT.CSV data source file.hen, after the data has been imported: Select the first column in the first line of the imported data. On the Insert tab, click the PivotTable button. The 'Create PivotTable' wizard appears. The Select a table or range option is already selected, and the Table/Range is automatically inserted by Excel.