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.
Here are the problems we look at: 1  New data not included when you refresh. 2  You want totals and percent of total. 3  You don't want a data sheet.  You don't like the automatic field 1  names. Your number formatting gets lost.  You want to see the data behind a 1  subtotal. Grouping one pivot table affects another.  Refreshing a pivot messes up column widths.