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.
Note If you want to be able to automatically update or refresh the data in your chart or graph, you must save the Excel file before inserting the chart or graph. In Excel, select the chart by clicking its border, and then on the Home tab, in the Clipboard group, click Cut.ote If you want to be able to automatically update or refresh the data in your chart or graph, you must save the Excel file before inserting the chart or graph. In Excel, select the chart by clicking its border, and then on the Home tab, in the Clipboard group, click Cut.