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.
To return to a normal layout of the pivot table, follow these steps: 1  1. Select any cell inside the pivot table. The PivotTable Tools tabs appear in the Ribbon. 2  2. Go to Design tab of the ribbon. 3  3. From the Design tab, open the Report Layout dropdown.  4. Choose Show in Tabular Form as shown in Figure 2.